Previous/Lag Function Not Working

Monpero

Hi,

I have 2 line item and on the other line item I used a Previous() function to try and get the last actuals value to spread it in forecast but it seems to not work, I also tried LAG() and same issue. What could possibly be the issue or is there a workaround on this please?

Below is the module, it is dimensioned by 2 list and Time.

Your input will be helpful, thanks.

BrunoRodriguez

Hello @innocent,

Can you please share the SYS01 content?

Cheers!

Monpero

Hi @BrunoRodriguez below is the sys01 dimensioned with version and time.

BrunoRodriguez

Hello @innocent ,

It seems like you SYS01 Actual Month is always TRUE. As such, it is never going into the second part of the if statement.

Once you resolve that bit a create a boolean that differenciates across forecast and actual period it will work.

Cheers!

Monpero

Hi @BrunoRodriguez thanks for the quick response. Sorry that I didn't show it in this view as you can see the actual isn't always TRUE. It's just not picking up the forecast for some reason I can't explain.

BrunoRodriguez

Hello @innocent ,

Do you have versions in your target?

Cheers!

Monpero

Hello @BrunoRodriguez no there isn't, that's probably the issue?
Thanks

BrunoRodriguez

Hello @innocent,

What is your Current Version? As the booleans for that one are probably being used. I guess that it will be always TRUE.

Cheers!

Monpero

Thanks @BrunoRodriguez the current version is the version below and for DEC 22 and it is checked as true. Atleast it should bring value in for DEC 22 for the current verison but it doesn't. I'm not too sure why it's not working.
Thank you very much for the response.

BrunoRodriguez

Hello @innocent,

Just create the filter in a module without versions.

Is this Innocent ****?

Cheers!

Monpero

Hello @BrunoRodriguez thanks 😃😆😀

BrunoRodriguez

Nice VM versions :P