For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I achieve that?
@salil.nirula
movingsum() will perform better
Have you tried using Movingsum()?
I think its the OFFSET function, got the desired values. Thank you for response :)
Oh ok.sure will try that as well. Thank you
@rob_marshall how movingsum would be performing better than lag in this case when only one number needs to be calculated from previous periods?
@pyrypeura
Because MovingSum(line item,-12,-12) will perform faster than Lag(line item,12, STRICT/SEMI STRICT) which will perform better than LAG(line item,12).
@rob_marshall so based on this it would be best practice to never use LAG/OFFSET as you can achieve same functionality with MovingSum which would always be performing better even if it's only one time item at a time you want to get?
In this case, LAG(line item, 12) and MovingSum(line item, -12,-12) will return the same number, which in this case is the same member of the previous year which is what the original poster was asking. But, to your question, movingsum does perform better than lag/next().
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Rankingβ¦
