Skip to Content
0
Former Member
Oct 20, 2017 at 04:12 PM

Format measure as percentage (number, not string)

2881 Views Last edit Oct 30, 2017 at 02:59 PM 2 rev

Hello,

I would like to add a measure that is formatted as a percentage and is still a number (not text). I tried this formula:

=FormatNumber(Actual;"#,##0.0[%]%")
This returns the correct format (42.1%), but it is now a text because of the %-sign.

Since it is a text, I can't use the ToNumber function either. I know that I can format the column manually when I add the measure to a table, but I would like to format it completely in the function for several reasons.

Can anyone please help me?