SAP IBP Analytics Stories Calculated Measure not returning expected results

[vincent_kh_chen]

Hi community members,

I have created a calculated measure in SAP IBP's Embedded SAC (Analytics Stories) as screenshot below.

I was expecting the "Forecast Changes" calculated measure to return the difference between "Latest Forecast" and "Forecast Snapshots". However it was returning expected results in only one month (green rectangle) and nothing in the other months (red rectangles).

Both key figures in the calculation are stored key figure with aggregation mode of sum and therefore are believed to be able to derive calculation results of a subtraction.

Any insights are greatly appreciated.

Thank you.