Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 13, 2023 10:53 AM
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
Solved! Go to Solution.
Sep 14, 2023 03:29 AM
for example like this
IF(
{Rollup profit ($)},
"$" & {Rollup profit ($)}
)
&
IF(
AND({Rollup profit ($)},{Rollup profit (%)}),
", "
)
&
IF(
{Rollup profit (%)},
INT({Rollup profit (%)}*100) & "%"
)
Sep 13, 2023 06:01 PM
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
Sep 14, 2023 01:04 AM
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
Sep 14, 2023 02:24 AM
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) & "%"
Sep 14, 2023 02:48 AM
@Sho When using the formula
Sep 14, 2023 02:57 AM
A little more!
"," is also a string.
"$" & {Rollup profit ($)} & ", " & INT({Rollup profit (%)}*100) & "%"
Sep 14, 2023 03:01 AM
That's a lot better thank you very much
Last bit.....Is there a way to remove the excess symbols?
Sep 14, 2023 03:29 AM
for example like this
IF(
{Rollup profit ($)},
"$" & {Rollup profit ($)}
)
&
IF(
AND({Rollup profit ($)},{Rollup profit (%)}),
", "
)
&
IF(
{Rollup profit (%)},
INT({Rollup profit (%)}*100) & "%"
)
Sep 14, 2023 07:10 AM
If you mean floating point issue when displaying currency value, use ROUND({Rollup profit ($)}, 2) , for example, to preserve 2 digits after comma.
Sep 15, 2023 12:23 AM
thank you very much!!