Stopping a KF calculation due condition, and saving the result in only one bucket - SAP IBP

[RodrigoRochaCordeiro2024]

Dear Community experts,
I’m facing with a KF creation for don’t calculate two buckets after a freeze horizon as below. These horizonts are variable depends on "transportation freeze horizon" .

We can’t copy from a calculated KF to a stored KF and purge the buckets values, due business rules won't work .

Example :

Anyone suggest how to do ?
BR

[fabio_perfetto · Accepted solution]

Hi Rodrigo,

You can introduce 2 calculated key-figures, KF2 e KF3:

KF2: use the IBP_CAGGR (cumulative aggregation) function to determine the cumulative sum of the original key-figure KF1.

KF3: implement a simple calculation to compare KF1 and KF2 and evaluate KF3 only in case KF1=KF2.

Hope this helps.

BR