Combining Lag and Snaphot KF's in one KF

[Nikhil_S1]

Dear Experts,

We have a business requirement to merge lag and snapshot Key Figures (KFs) into a single KF. One approach is to create separate lag KFs for each lag and reference both the lag and snapshot KFs in the final KF calculation.

However, I would like to know if it is possible to achieve this without creating multiple intermediate KFs.

The requirement is as follows:

• If the period is less than the current period minus 1, then show lag 1.
• Otherwise, show snapshot 2.

Can anyone provide a formula for the KF calculation that meets these requirements?

Thanks in advance for your help!

Regards,

Nikhil