Concatenate a number to a string

[#1]

Hi all,

I have a Text object used to display the result of the following equaction:

= if(round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100)>0,round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100),0)

As this calculation displays percentage, I'd like to append it with the percentage sign "%". How can I do it? The following formula didn't work thogh:

= if(round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100)>0,round(sum(Value)/sum({$<Product_Name=, Account_Name=>} TOTAL Value)*100),0) $ '%'

Any suggestion is appreciated.

[#2 · Accepted solution]

Hi ahmedb,

Replace '$' with '&' without the quotation marks.

- Lester

[Oleg_Troyansky]

I'd recommend formatting the number using function num:

num( ... , '#,##0.0%')

This way, not only you get the desired %-sign, but also the number will be limited to a required number of decimals and, if needed, show a thousand separator. Keep in mind that you don't need to multiply by 100 - it will be done automatically...