Skip to Content
0
May 07, 2020 at 05:46 PM

SAP IBP Key Figure calculation with Nested If

429 Views

Hi,

We have Plan order calculation as below :-

PLANORDER=TOTALRECEIPT-MINTRANSPORT

If it is less than 1 then Null

PLANORDER@WKPRODLOC = IF(("TOTALRECEIPT@WKPRODLOC" - "MINTRANSPORT@WKPRODLOC") < 1,NULL,"TOTALRECEIPT@WKPRODLOC" - "MINTRANSPORT@WKPRODLOC")

Now requirement is :- to add one more condition

IF "STOCKINGNODETYPE" = 'N' AND "NETDEMAND@WKPRODLOC" > 0 then Null

Else

PLANORDER@WKPRODLOC = IF(("TOTALRECEIPT@WKPRODLOC" - "MINTRANSPORT@WKPRODLOC") < 1,NULL,"TOTALRECEIPT@WKPRODLOC" - "MINTRANSPORT@WKPRODLOC")

===================================================================================

STOCKINGNODETYPE is attribute

Can you suggest the full calculation formula please

regards

Safia