nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to use Timesum function?

NareshShahus

In Level 2 sprint i got stuck at Timesum function, please help me out

Accepted answers

Tiffany.Rice

Hi Naresh, what in particular has you stumped?

The TIMESUM function is used when we want to calculate the value of between specific periods of time (or for all time periods). When using this function, the module should not have a time scale applied.

https://help.anaplan.com/timesum-45c3bc48-4d80-490d-9b18-76af505c6907

All comments

Tiffany.Rice

Hi Naresh, what in particular has you stumped?

https://help.anaplan.com/timesum-45c3bc48-4d80-490d-9b18-76af505c6907

Badam

Hi Naresh,

The Timesum function is used to aggregate values over a specified time range. It calculates the sum of a specified line item or expression for a given time period.

https://help.anaplan.com/timesum-45c3bc48-4d80-490d-9b18-76af505c6907

Identify the line item or expression you want to aggregate. Let's say you have a line item called "Sales" that you want to sum over a specific time range.
Determine the time range over which you want to aggregate the values. This can be done using time periods or references to time dimensions in your model. For example, you might want to sum the sales values for the past three months.
Timesum(Line Item or Expression, Start Time Period, End Time Period)In our example, the formula would look something like this: Timesum(Sales, Current Period - 2, Current Period)Here, we are summing the "Sales" values from the current period minus 2 (two months ago) to the current period.
Apply the Timesum formula to the desired target cell. This could be in a module or a dashboard, depending on your use case.

If the above answer helps you out, please accept it as a solution, which motivates us to contribute more.

Thanks

Badam Anjani Prasad

Matasma Digital Technologies

sobaid

Hi @NareshShahus , follow the syntax to levarage your formula creation in a target module(with no time dimension) where Line item to aggregate, Start period, end period can be mapped from source module,

TIMESUM(Line item to aggregate [, Start period] [, End period] [, Aggregation method]

Liampratt

Hello, To assist you with the "Timesum" function in Level 2 sprint, I need more details about the specific problem or challenge you are facing. Please provide more information or specify the issue you are encountering with the "Timesum" function, and I'll be happy to help you with a solution or guidance.

Liampratt

Thanks for the info.

Quick Links

Can you help?

Unanswered questions

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…