Skip to Content

Format measure as percentage (number, not string)

Oct 20, 2017 at 04:12 PM


avatar image


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

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?

10 |10000 characters needed characters left characters exceeded

SAP BusinessObjects

* Please Login or Register to Answer, Follow or Comment.

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.


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

10 |10000 characters needed characters left characters exceeded