BEx Fixed Unit of measure display in a Formula
I have got a formula in BEx Query, it has an if else condition to display the value. the first part is when if condition is true, display the value in a keyfigure else display fixed value 100%.
The displaying keyfigure is created in back end, it is defined with % as Fixed unit of measure. So, the first part of the condition is working fine, the else part I am unable to display the constant value as '100%', I am wondering how can define fixed unit of measure in BEx formula for a constant value?
Do you know, how can I display it?
Sreekanth Surampally replied
Yes Loed, I have tried it, new column can display the % associated with number, but if it is used in other formula it would result in 100,
finally we convinced the user to display 100 for some records and some would display as 100% format, it is fine now.
Thanks you very much all the help you provided, highly appreciated your effort.