Replace null values by zero for stored key figure in SAP IBP

[g_basavaraj]

Hello Folks,

How to replace null values by Zero for stored key figure in IBP?

[riyazahmed_ca2]

Hi Basavaraj,

Very easiest way is to change this keyfigure to Stored and Calculated.

KF@Request = SUM(KF@PL(calculated values)

KF@PL = IF(ISNULL(KF@PL(stored values), 0, KF@PL(stored values))

Best Regards,

Riyaz

[girish_nitie]

Hi g_basavaraj

One way to achieve the same is to create a calculated KF with logic to replace NULL with zero otherwise use sames values then using copy operator you can copy this back to original stored KF.

Thanks

Girish

[manikandan_shanmugam3]

Change KF as Calculated and Stored keyfigure and write a logic as below.

if (ISNULL(KF),0.KF)