IBP - future 13weeks rolling average

[bkreddy]

Hello All,

what is the expression to calculate future 13w rolling average stored in current bucket. Below expression considering 13W for future periods, but 14W average for the current bucket.

[manikandan_shanmugam3 · Accepted solution]

Hi BK,

Lokesh was right, Please check your configuration.

Regards,

Mani

[lokesh_reddy4]

Hi BK Reddy,

Maintain "Duration" values in the key figure expression as 13 instead of 14 and try.

Thanks and Regards,

Lokesh Reddy

[bkreddy]

Thanks for the quick response.

[bkreddy]

Hi Mani,

Thanks a lot for your time and detailed screenshots, Its working as expected now.

[bkreddy]

Hi Lokesh,

If the duration is 13, current bucket value is correct but future values are wrong.

Thanks,

BK