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 am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplanβ¦
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (notβ¦
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7β¦
