Days() Function

Highlighted
Valued Contributor

Days() Function

Hello everyone,

The below screenshot is from one of the mini videos of Anaplan.
image.png

How can one adjust the "Summary Settings" to get the number of days in a quarter or a year?
I know of 2 ways to return the number of days in a quarter or a year when using the Days() function:

  1. To change the time scale for either a quarter or a year. (this will create a subsidiary view)
  2. To explicitly add the period as a parameter to the Days() function such as DAYS(Current Quarter)/DAYS(Current Year)

Can someone please explain to me how to use the Summary setting to get the number of days in a quarter or a year? 

 

Thanks

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: Days() Function

@einas.ibrahim 

I think you're right. One way is to change the time period.

But honestly, to get the day count I would create a system module for each of the periods needed. Calculate once.

Creating subsidiaries isn't very PLANS friendly, although I don't think it impacts performance.


Jared Dolich
Highlighted
Valued Contributor

Re: Days() Function

Hey @JaredDolich 

 

You know, I just recently noticed that we create a different time system module for different time scales (weeks, months, year).

I have always seen one Time Filter module for all time related settings. 

I believe the Function model is designed this way as well as the “old” Time Filter model.

 

I believe it’s because of your point of avoiding subsidiary views for best practice. 
I understand the importance of not overusing subsidiary views but I’m yet to find it very relevant when creating a times filter module. Having all the time settings in one module is still attractive to me. I’m sure I’ll adopt to the new methods at some point soon. 

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Master Anaplanner/Community Boss

Re: Days() Function

@einas.ibrahim 

 

It is cleaner and easier to maintain if they are in separate modules.  If you need the filter for quarters, you go to SYS Time Filter - QTRS, if you need one for Years, you go to SYS Time Filter - Year, etc.  There is no performance or space savings doing it either way.

 

Rob

Highlighted
Certified Master Anaplanner

Re: Days() Function

My understanding is that it was a way of saying that the summary methods work with this formula.

 

You can have a month time scale and still use the SUM or FORMULA summary method to calculate the number of days in Quarter or Year, etc.

 

jasonblinn_0-1591723393207.png

jasonblinn_1-1591723475944.png

 

Jason

Highlighted
Valued Contributor

Re: Days() Function

Thanks @jasonblinn 

 

The way you presented would certainly get us the days in a quarter and days in a year albeit not as a separate line item

 

I’m a stickler for accuracy of words. so when it says “adjust the summary method” it seemed to me as saying if you change the summary from X to Y then the formula will return the number of days in a quarter for example, which I know it’s not accurate. 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"