Summing from week to quarter between timeranges

Hi everyone,

I have encouterend a problem that keeps bugging me, so I would like to share this with you guys!

In a model I have two timeranges:
Model timerange: 2 years, months, no quarter totals.
additional timerage "Long term": 5 years, quarter totals.

Module A: Model timerange:
Lineitem 1: timesettings: weeks

Lineitem 2: timeformatted item that contains the Quarter of that month.

Module B: Time range "Long Term".
Lineitem 1: timesettings: Quarter.
I would like to use the formula for module B: ModuleA.Lineitem1[SUM:ModuleA.Lineitem2]

Sadly this doesnt work.

The only way i have found to direct the data from module A to module B, is to make a lineitem that is weekly 'formatted' in stead of quarter formatted. This will cost us an excessive amount of cells, just to convert between time (TImerange 1: weeks, tot timerang2: quarters).

Does anyone have a better solution for this problem?

Kind regards,
Ralf

Accepted answers

rob_marshall

Sorry, you asked for Quarters and I showed Months. Essentially, it is the same concept.

Quarterly Time Filter:

Quarterly Summary Module:

Hope this helps,

Rob

All comments

rob_marshall

@RalfdeGier

Have you tried using the function TimeSum? Try the following which I believe will help you. Create a Time Filter module with Months as the basic Time Range (so the module is defined at the month level) and create two line items: Start Week and End Week with the following formulas:

I have a transaction module with data at the weekly level:

In my summary module at the month level, I have a formula using TimeSum

Hope this helps,

Rob

rob_marshall

Sorry, you asked for Quarters and I showed Months. Essentially, it is the same concept.

Quarterly Time Filter:

Quarterly Summary Module:

Hope this helps,

Rob

RalfdeGier

Thanks Rob,

Works like a charm!

Kind Regards,
Ralf

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…