Days() Function

Hello everyone,

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

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:

To change the time scale for either a quarter or a year. (this will create a subsidiary view)
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

Accepted answers

jasonblinn

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.

Jason

All comments

JaredDolich

@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.

jasonblinn

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.

Jason

einas.ibrahim

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.ibrahim

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.

rob_marshall

@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

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…