Anaplan Last year values Summary(Formula)

I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary from none to formula)

Accepted answers

All comments

rob_marshall

@shlokhan

Why do you need the summary to be Formula? And the function I would us is either LAG() with the STRICT option as the 4th parameter or movingsum().

shlokhan

Formula summary is converting imported monthly data into quarters, years data. Since Module A is week based, Module B isn't populating data for Quarter, Year.

rob_marshall

@shlokhan

You don't need the summary to be Formula, just Sum.

shlokhan

In that case Jan- 20%, Feb- 40%, Mar- 25%, Q1 would be 85%. That's not how I want. Any other turnaround to use Lag, Offset or any other function to bring last year/quarter/month values?

rob_marshall

@shlokhan

Well, you didn't specify that, I was only going on what you stated. What are you wanting for Q1 with those percentages?

shlokhan

Bringing weekly x and y data from Module A into Module B which has time range of Month, Quarter and Year. Let module B do calculations of x and y to show data of Last year.

So is there any function/formula which can calculate the last year data but not making 20% + 40% + 25% = 85%. But instead calculating x and y to show its own Quarter data.

Quick Links

Can you help?

Unanswered questions

UX Filter
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…
Dimensionality Issue
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…
Formula to return Connection details...
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?