Skip to main content

Hi there,

I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be greatly appreciated,

Bart

Hi @bartdubs,

Two fields can be displayed as one by using the "&" operator symbol in the Formula field.

Name & " - " & Age
=> Jane - 28

"\\""&{Product Name}&"\\""
=> "GreatProduct"

Name & " \n" & Age
=> Jane
28

Formula Field Reference - Overview | Airtable Support

Hi @bartdubs,

Two fields can be displayed as one by using the "&" operator symbol in the Formula field.

Name & " - " & Age
=> Jane - 28

"\\""&{Product Name}&"\\""
=> "GreatProduct"

Name & " \n" & Age
=> Jane
28

Formula Field Reference - Overview | Airtable Support


Hi @Sho 

Thanks that makes sense. However, when I do that it inserts both values as basic numeric values. How would I be able to do it where it keeps the percentage as a percentage and the $ value as a $ value?

Thanks,

Bart

If you want to display percentages or amounts as strings in the Formula field, you must also write such formatting yourself.

"$" & {Value}

INT({Value}*100) & "%"

 

@Sho When using the formula

 

"$" & {Rollup profit ($)}, INT({Rollup profit (%)}*100) & "%"
 
It is just saying invalid formula. Is there any specific reason this might be?
(The fields labeled as rollup are both lookup fields)

A little more!
"," is also a string.

"$" & {Rollup profit ($)} & ", " & INT({Rollup profit (%)}*100) & "%"

 

A little more!
"," is also a string.

"$" & {Rollup profit ($)} & ", " & INT({Rollup profit (%)}*100) & "%"

 


That's a lot better thank you very much

Last bit.....Is there a way to remove the excess symbols?

for example like this

IF(
{Rollup profit ($)},
"$" & {Rollup profit ($)}
)
&
IF(
AND({Rollup profit ($)},{Rollup profit (%)}),
", "
)
&
IF(
{Rollup profit (%)},
INT({Rollup profit (%)}*100) & "%"
)

That's a lot better thank you very much

Last bit.....Is there a way to remove the excess symbols?


If you mean floating point issue when displaying currency value, use ROUND({Rollup profit ($)}, 2) , for example, to preserve 2 digits after comma.

for example like this

IF(
{Rollup profit ($)},
"$" & {Rollup profit ($)}
)
&
IF(
AND({Rollup profit ($)},{Rollup profit (%)}),
", "
)
&
IF(
{Rollup profit (%)},
INT({Rollup profit (%)}*100) & "%"
)

thank you very much!!

Reply


Terms & Conditions