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().
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
