ALLPERIODS Value function

We currently have time functions to return the MONTHVALUE, QUARTERVALUE, YEARVALUE etc... it would be helpful to add a final function which will return the Time.All Periods value, this would enable developers to avoid having to add summary methods to determine the all periods value.

It may be there is a work-around but ran into this today and felt this function would have saved me creating a couple of line items which I didn't need.

Comments

DavidSmith

@sean_culligan

Any reason why [SELECT:Time.All Periods] is not an option?

David

sean_culligan

@DavidSmith

My case is where I don't want to add a summary just for the sake of getting and all periods value.

So in the case below, I have a monthly module with values:

Jan 19	Feb 19	Mar 19	Q4	FY	All Periods
10	20	30	-	-	-

Without needing a summary method, I can get the QUARTERVALUE and YEARVALUE, but I can't get ALLPERIODS. I could only get the all periods if I added a summary method and then did the select.

Where I would commonly use this is on a large inbound module where you are checking for empty records. If I could avoid having to add summaries then that would save me a fair amount of space.

DavidSmith

OK, makes sense

If your target module doesn't have time, you can also use TIMESUM(), with no parameters

David

sean_culligan

@DavidSmith

Thanks, I should have thought of that really. This request looks to be resolved then 🙂

Quick Links

New ideas

Anaplan XL Freeform - ability to multi-select in filters
In Anaplan XL Freeform, we would like to specify multiple members on dimensions that apply to the whole report (filters, not rows or columns). This is possible in grids but not yet in freeform.
Clarifying Anaplan’s SSO X.509 Certificate Rotation Process
🔐 Understanding the Anaplan X.509 Certificate Rotation Email (Note: This email is sent to Tenant Security Administrators or Tenant Administrators within your Anaplan Tenant) When you receive an email from Anaplan like this: Email Sample: Hi, Your Anaplan Certificate for SSO needs to be rotated by July 16, 2025 (IST) for…
Administration Console: Keep Last login in Date format, on top of new format
It is great to know how old is the Last Login, but: 1.It would be great to keep the old Date format as well, to be able to make more easily some ad hoc analysis (older than X days, months etc…, as shown in example further below). The filter on new format is not possible and would not be meaningfull. 2.It would be great to…