Key Figure Calculation Behaving Strange

[aishani_das]

Hi Experts,

I am facing a strange issue. There is a stored key figure (ZBGMTHSCOPY ) at PERPRODLOC base planning level that stores the value of another stored and calculated key figure (ZBGMTHSTOQTY). ZBGMTHSTOQTY has an IBP function written which it calculates correctly and ZBGMTHSCOPY also shows the correct value when checked in a planning view template. However, when I check the stored value of ZBGMTHSCOPY in "Planning Objects with Key Figure Data", the value is not getting stored in the database.

ZBGMTHSCOPY@REQUEST = SUM("ZBGMTHSCOPY@PERPRODLOCUOMTO")

ZBGMTHSCOPY@PERPRODLOCUOMTO = "ZBGMTHSCOPY@PERPRODLOC" * "UOMCONVERSIONFACTOR@PRODUOMTO"

ZBGMTHSCOPY@PERPRODLOC = IF(ISNULL("ZBGMTHSCOPY@PERPRODLOC"),"ZBGMTHSTOQTY@PERPRODLOC","ZBGMTHSCOPY@PERPRODLOC")

Has any of you faced this? If yes, how did you resolve it? Your kind help is much appreciated.

Regards,

Aishani

[rahulmohnot]

Hi Aishani,

Can you please share the complete snap as I am confused. Although you say ZBGMTHSCOPY is stored but you show below the calculation for the same key figure.

ZBGMTHSCOPY@PERPRODLOC = IF(ISNULL("ZBGMTHSCOPY@PERPRODLOC"),"ZBGMTHSTOQTY@PERPRODLOC","ZBGMTHSCOPY@PERPRODLOC")

I am not able to understand the KF properties and formulation. Please elaborate.