Skip to Content
0
May 13, 2022 at 08:10 AM

Key Figure Calculation Behaving Strange

100 Views

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