How to get the value into one time period by comparing the values in the previous time period

[bindhu_konidala]

Hello Experts,

I have a requirement to get the value into one time period by comparing the value in previous time period.

In the below screenshot key figure 'Phase IN % Effective' 's value is 100 in time bucket 2019TW33. I want to make the next time bucket's values(

2019TW34,

2019TW35a,

2019TW35b......and so on )

also 100 once 2019TW33 value becomes 100

Please kindly help on the above requirement.

Thanks in Advance.

[ankpatel · Accepted solution]

Hello,

Assuming 2019TW33 is current week and always future periods will be NULL, what you have to do is create a staging KF@PL and using copy operator just copy the current period value with offset of 1. Now using Helper HELPKF@PL = IF(( "PERIODID6" > "$$PERIODID6CU$$" AND ISNULL( "Phase IN % Effective" )), "KF@PL,NULL)

Doing so you will get the Phase IN % Effective current week value in all future periods which you can use in your calculation.

Regards

Ankur