Retrieving a date to a module without time dimension

Hi All,

I have a question regarding the last date of an item, to a module without dimension.

Let me explain, i have this module :

with thoses dimensions :

My purpose is to get the result of the input in a module only dimensionned by "s Active" (subset of my employee list) and regarless the version, to get something like this something like this

I tried with the Select Time.All Period but the model does not have total or summary.

Any leads i could try ?

Accepted answers

Tiffany.Rice

https://help.anaplan.com/timesum-45c3bc48-4d80-490d-9b18-76af505c6907 formula can be used to aggregate time dimensioned data using a variety of aggregation methods: SUM, AVERAGE, MIN, MAX, ANY, ALL, FIRSTNONBLANK, LASTNONBLANK, and TEXTLIST.

All comments

Tiffany.Rice

Sai_Bharadwaj_Venati

I don't think you can pull data directly without top level into another module with straight forward formula.

Couple of alternate approaches: -

Option 1: Create a fake version list with top level and map it to native versions for pulling data and you can use last non blank for getting date summary

Option 2: If fake version list doesn't have top level, you can create a new dummy list and keep it in target module dimensions. In source module create a line item formatted by dummy member and aggregate the source numbers into target module by using sum.

Note in Option 2 you wouldn't be able to sum by date, you should create a number equivalent to date and get the values. once you get the value with summary you should get back the date

HugoVolpi

@Tiffany.Rice it worked ! thank you, i have forgotten it could be also handling dates, thank you.

@Sai_Bharadwaj_Venati indeed, if not for the timesum function, your case was working too.

Thank you all,

Regards,

Sai_Bharadwaj_Venati

@HugoVolpi can you share the formula once? You are using native versions which dont have summary and in your target as well you dont have native version

HugoVolpi

I hide the 3 names before the two lines items "Date de Sortie" and "Date de Sortie Final"

HugoVolpi

@Callahan09 was it directed to me ?

If yes, what about reading two messages above where i am thanking them and sharing my formula ? I hope i am wrong on my assumptions because if it was , you didn’t read anything about the conversation and just accused me with a bad comment and being condescending for nothing

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…