In the line item "last 3 months sum", I'm trying to sum the last three months.
I tried using timesum but wasn't getting the right numbers.
Any help appreciated, thanks!
Hi @ashasli, Try using MOVINGSUM().
You can also watch this legendary video by Rob. TIMESUM vs. MOVINGSUM
I hope this helps.
Seyma π·π
Thanks @seymatas1 it worked! MOVINGSUM(last 3 months, -3, -1, SUM)
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large βProjectsβ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column isβ¦
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?
