Skip to Content
0

Format measure as percentage (number, not string)

Oct 20, 2017 at 04:12 PM

64

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
Former Member

SAP BusinessObjects

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

1 Answer

AMIT KUMAR
Oct 30, 2017 at 03:17 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded