Understand KF Logic

[reddyatoz]

Hi Experts,

can someone explain logic for below mentioned expression

'=IF(AND(ISNUMBER(ZFPPIPXCONTROL);ZFPIMSFORECASTQTY>0);+ZFPIMSFORECASTQTY-ZDPCONSTRAINEDFORECAST;0)

=IF(AND(ISNUMBER(ZFPPIPXCONTROL);ZFPIMSACTUALQTY>0);+ZFPIMSACTUALQTY-ZDPACTUALSQTY;0)

Br

Kumar

[former_member811144]

Hi Kumar, these statement appears to do the following:

If the KF ZFPPIPXCONTROL (looks like to be a local member) has value AND ZFPIMS > 0, then the system will subtract the respective values, otherwise it will be 0.

Best Regards,
Jorge Serpa.

[reddyatoz]

Hi Jorge Serpa,

Thanks for the response.

But when i try to create helper KF with this logic getting "syntax error".

IF(AND(IsNumber("ZFPPIPXCONTROL@MTHPRODCUST");"ZFPIMSFORECASTQTY@MTHPRODCUST">0);"ZFPIMSFORECASTQTY@MTHPRODCUST"-"ZDPCONSTRAINEDFORECAST@MTHPRODCUST";0)

Can you help me where i am missing exactly.

Br

Kumar

[reddyatoz]

Hi Jorge Serpa,

Modified expression like below. Just wanted to know that it is correct or am i doing any mistake.

IF(ISNUMBER("ZFPPIPXCONTROL@MTHPRODCUST")AND("ZFPIMSFORECASTQTY@MTHPRODCUST">0),("ZFPIMSFORECASTQTY@MTHPRODCUST"-"ZDPCONSTRAINEDFORECAST@MTHPRODCUST"),0)

Br

Kumar

[former_member811144]

Kumar, the expression that you mentioned, is it inside a KF calculation in Fiori, or are you using it as a local member in Excel Addin?

[reddyatoz]

Jorge Serpa, it is inside a KF calculation in Fiori