How to writa formula in Key figures - Syntax

[Former Member]

Hi All,

I am new to SAP - Infact beginner, I started doing Bex Reporting. However I got stuck in calculated key figures

Below is the formula i am working on:

Local OSMI Category = If RNR = 90 or 99 then "1", else if Local Orderbook = 0 and Local History = 0 then "2", else if Current inventory > Months on Hand specified at local level then "3"

Please let me know how to write the above formula in Key figures area...(syntax)

Thanks & Regards,

Srikanth

[Former Member · Accepted solution]

Hi Srikanth

If only one of the 3 conditions that you have mentioned holds true at a time and RNR, Local Orderbook,Current inventory,Months on Hand KFs are available in the report then you can write the formula for Local OSMI Category KF using Boolean logic as below:

1((RNR==90) OR (RNR== 99)) + 2((Local Orderbook == 0) AND (Local History == 0) + 3*(Current inventory > Months on Hand)

Hope this solves your problem.

Regards,

Ninad

[Former Member · Accepted solution]

Hi NInad,

Thanks for your reply!!!

Eventhough when i applied the same logic the results are not satisfactory...Seems like this formula is skipping the 2nd statement i.e., when( Local Order Book = 0 And Local History = 0) It sholuld give 2 instead i am seeing either X or 0 for this...

Could you please look into this...

Regards,

Srikanth

[ravi_chandra3 · Accepted solution]

Hi pitchis,

try this formula i think u will get now

((RNR==90) OR (RNR== 99)) * 1 + ((Local Orderbook == 0) AND (Local History == 0) ) * 2 + (Current inventory > Months on Hand) * 3

Regards,

RaviChandra