Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BEx Fixed Unit of measure display in a Formula

Hi,

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?

Thanks

Sreekanth

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.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question