QUARTERVALUE Function

Hi team,

I've got 2 simple modules with 2 dimensions, Accounts & Time. The source module has the Model Calender with Month as the Time Scale. The target Module has a Custom Time Range with Quarter Totals selected & has Quarters set as the Time Scale. Both Summaries are set to Sum

When I reference the source module using QUARTERVALUE function from the Target module there are no values returned. My understanding was that it would return the sum of the Quarter value?

Thanks!

Mark

Source_Module_-_Grid_60685.PNG

Source_Module_-_Blueprint_60685.PNG

Target_Module_-_Grid_60685.PNG

Target_Module_-_Blueprint_60685.PNG

Accepted answers

LipChean_Soh

Hi @MarkTurkenburg

The source needs to have 'Quarters' turned on, in order for QuarterValue to work as shown below in 2 different scenarios:

1. M1 is the source for both M2 and M3. Note that M1 has Quarter in its Time.

Screen Shot 2020-02-17 at 20.13.05.png

2. M3 is the source for both M1 and M2. Note that M3 is at Quarter level.

Screen Shot 2020-02-17 at 20.14.38.png

Thanks,

LipChean

All comments

LipChean_Soh

Hi @MarkTurkenburg

The source needs to have 'Quarters' turned on, in order for QuarterValue to work as shown below in 2 different scenarios:

1. M1 is the source for both M2 and M3. Note that M1 has Quarter in its Time.

Screen Shot 2020-02-17 at 20.13.05.png

2. M3 is the source for both M1 and M2. Note that M3 is at Quarter level.

Screen Shot 2020-02-17 at 20.14.38.png

Thanks,

LipChean

MarkTurkenburg_*8288

Thanks @LipChean_Soh

The problem I am trying to solve is there a certain presentation modules within my model where I would like to view them only in Quarters. Rather than turning on Quarters for the Model Calendar, which will materially increase the size of the model, I created a Custom Time Range with Quarters turned on. Currently I create modules whereby:

* Calendar is the Customer Calendar with Quarters turned on

* Time Range is set to Month, which then aggregates up to Quarters

* Filter our the months so only the Quarters are visible

Is there any way I can bypass the Months rolling up into Quarters, set the Time Range to Quarters & return the values when referencing a line item without Quarters?

Thanks

Mark

LipChean_Soh

Hi @MarkTurkenburg

Do see if the following works, the results are shown in'M3 - Qtr Only'.

The only formula not shown is:

Quarter Details.Start Mth = Period(Start())

Screen Shot 2020-02-17 at 20.56.13.png

Thanks,

LipChean

MarkTurkenburg_*8288

Thanks @LipChean_Soh

Nice solution!

Mark

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…