Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 27, 2015 at 04:13 AM

    Hi, Actually, I am not expecting a constant value in that formula, as I said earlier, I have a formula defined with if else condition, the else part is to get 100 %. I can put the formula to display 100 but not 100%, I am wondering is there any I can show 100% in the report output.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Oct 27, 2015 at 02:36 AM

    Hi Sreekanth,

    you can create a new formula for constant value like below

    - (0 % 100)

    this will give you the constant value as 100% for each row. In the else place, use this column to populate.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 03:07 AM

    Hi,

    You can find a very useful doc (for the first way, BEx) following this link https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to report data in alternate units of measure

    Otherwise, if for you it's not necessary to have the indication of the UoM with your amount

    On the other hand, you can use the update rules to convert your UoM when you load data in the infoprovider !

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 04:56 AM

    Hello Sreekanth,

    pls share ur formula.

    yes , in some cases else part will not work.So instead of else part u can make it to if condition in formula.

    ex. suppose if your formula is like: PO = 100 then 1 else 0.

    so instead of using PO ='100' * 1 + 0

    u can use              (PO = '100') *1 + (PO <> '100') *0

    check this workaround .

    Regards,

    Hitesh Gavande

    Add comment
    10|10000 characters needed characters exceeded