SAP IBP - Adjusted key figure calculation definition isn't working

[Daniele_Cuozzo]

Hi,

We need to create an editable key figure  ZZTESTACTQTY2(adjusted)  initialized with ACTUALSQTY if ZZTESTACTQTY2 has no value

Calculation definition --> ZZTESTACTQTY2@WKPRODLOCCUST = IF(ISNULL("ZZTESTACTQTY2@WKPRODLOCCUST"), "ACTUALSQTY@WKPRODLOCCUST", "ZZTESTACTQTY2@WKPRODLOCCUST")

In this case the calculation work correctly, we did an adjustment only on TW42  2023. For this example we use standard IBP Key figure.

We tried to replicate the logic that you can see above, using a new planning level with a different time attribute (month)

with the same calculation definition-->ZZADJTEST@ZZMTHPRODLOCCUST2 = IF(ISNULL("ZZADJTEST@ZZMTHPRODLOCCUST2"), "ZZUSCITETEST@ZZMTHPRODLOCCUST2","ZZADJTEST@ZZMTHPRODLOCCUST2")

As you can see on the screenshot below , the new key figure isn't working

We need to know how to create this logic correclty , and we want to know the reason of the malfunction despite the logics being identical , as you can see it.

[vincentverheyen · Accepted solution]

Hi @Daniele_Cuozzo ,

The reason is because your Key Figure ZZADJTEST in its @Request level calculation does not reference its Calculated Value, instead it references its Stored Value (see the cube icon 🧊) in your screenshot of ZZADJTEST. 

This is different in the your Key Figure ZZTESTACTQTY2:where the @Request level calculation does reference the Calculated Value instead of the Stored Value.

Solution: please edit Key Figure ZZADJTEST in its @Request level calculation by clicking on 'Edit' next to REQUEST, and subsequently click on 'Inputs' and subsequently select 'Calculated' instead of 'Stored' next to ZZADJTEST@ZZMTHPRODLOCCUST2 .

Please let me know if there is anything which remains unclear. If not, you may mark this as a correct answer.

Kind regards,

Vincent Verheyen