Skip to Content
avatar image
Former Member

Format measure as percentage (number, not string)

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 30, 2017 at 03:17 PM

    If you want to use tonumber function after calculating percentage then use below to get the percentage only.

    =FormatNumber(Actual;"#,##0.0[%])

    or other option you can try if you want to display percentage column with number data type->formatnumber->select percentage format.

    Add comment
    10|10000 characters needed characters exceeded