cancel
Showing results for 
Search instead for 
Did you mean: 

SAP IBP Key figure calculation

bindhu_konidala
Explorer
0 Kudos
354

Hello Experts,

I have two key figures KF1@TWKPRODLOCCUST and KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL.

KF1 & KF2 are separate data loads.

I want to have a calculation as if KF1 is negative number(higher level) then KF2 values (detailed level) should become NULL (only for that PROD|LOC|CUST, for remaining it should consider the KF2 data load).

As the two KF's are on different PLs, I am facing issues.

Can you please kindly help on this calculation.

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

raghunathpartha
Explorer
0 Kudos

Hello Bindhu

Please try this config

KF2@REQUEST = SUM("KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL")

KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL = IF(ISNULL("KF1@WKPRODLOCCUST") OR "KF1@WKPRODLOCCUST">=0,"KF2@TWKPRODLOCCUSTCLASSCHARNAMECHARVAL"(Stored)",NULL)

The result will look like this: (Sample illustration)

Thanks and Regards

Raghunath

Answers (0)