Key figure logic

[former_member594111]

Hi All,

Anyone can help me write below Key figure logic in IBP

This calculation is at request level

• =1-ABS(IF(K1<1, 1, IF(K2<1, 1, (IF(K2>K1, (K2-K1)/K2, (K1-K2)/K1)))))

where K1=key figure 1

K2=key figure 2

Regards,

Abhijeet

[piyush_parekh · Accepted solution]

Hi Abhijeet,

You can try below key figure calculation at request level of target KF. I simplified the calculation a bit.

TargetKF@REQUEST= 1 - ABS(IF( "KF1@REQUEST" OR "KF2@REQUEST" < 1),1,IF( "KF2@REQUEST" > "KF1@REQUEST" ,( "KF2@REQUEST" - "KF1@REQUEST" ) / "KF2@REQUEST" ,( "KF1@REQUEST" - "KF2@REQUEST" ) / "KF1@REQUEST" ))

Please share if you are facing any specific issues.

If you are looking for commonly used key figure functions and expressions, you will find it here.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/1905/en-US/b8582c558934753ce10000000a17...

Regards,

Piyush

[former_member594111 · Accepted solution]

Thank you piyush