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().
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
