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)
Answers

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().
0 
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.
0 
You don't need the summary to be Formula, just Sum.
0 
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?
0 
Well, you didn't specify that, I was only going on what you stated. What are you wanting for Q1 with those percentages?
0 
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.
0