What is JF(...) instead of IF(...) formula in Key Figures

[vincentverheyen]

If you go to the sample planning area SAPIBP1, you will notice, for example in the key figure "Local Demand Plan Qty Final" (FINALLOCALDEMANDPLANQTY), the following formula:

FINALLOCALDEMANDPLANQTY@WKPRODLOCCUST = JF("ADJLOCALDEMANDPLANQTY@WKPRODLOCCUST">=0, "ADJLOCALDEMANDPLANQTY@WKPRODLOCCUST", "LOCALDEMANDPLANQTY@WKPRODLOCCUST")

Why did SAP use JF(...) here instead of a conditional IF(...)? What is the difference?

[manikandan_shanmugam3]

The JF statement will yield the else part in the event that the key figure used for the condition is null, whereas the IF statement will yield null when the condition key figure is null.

e.x

KF1 = null

if ( kf1>0, kf2, kf3) --> this will return null when you use if statement

jf( kf1>0, kf2, kf3) --> this will return kf3

Regards,

Manikandan Shanmugam