How to calculate cumulative results

Highlighted
Contributor

How to calculate cumulative results

Hi,everyone.

 

I would like to calculate the cumulative result of a line item.

I think I should use the TIMESUM function, but I don't understand how to use it.

 

image.jpg

I want to get the cumulative result from the date of FROM to the date of TO. Could you tell me the best solution?

 

Best regards.

Taku

7 REPLIES 7
Highlighted
Certified Master Anaplanner

Re: How to calculate cumulative results

Hi @takushimozuru,

 

Here assuming that Time dimension in Module is in Months, also the start period and end period is also in Month format, you could use the Timesum formula as below...

 

Timesum(Price, From, To )

 

 

Highlighted
Contributor

Re: How to calculate cumulative results

Hi, @Rashmih 

Thank you for your reply.

 

I tried it and I couldn't. Because "From" And "To" are Date format.

Could you tell me another good solution?

 

Best regards.

 

Taku

Highlighted
Certified Master Anaplanner

Re: How to calculate cumulative results

Could you please let me know the time dimension in the module..

If the numbers are to be summed by month, then we can convert the From and To date to Month and then use it in the formula.

Period Month = PERIOD(Date)
where the result (Period Month) is time period-formatted as Month and the Date source line item is formatted as Date.

For more details refer to this page, https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/PERIOD.html

Hope this helps...
Highlighted
Super Contributor

Re: How to calculate cumulative results

@takushimozuru 

 

You can try this:

1. Create a system module to select the " From & To Date"

Screenshot_29.png

2. In your module just add two line item one to check the time range and second to cumulative price:

Screenshot_30.png

now you can write a formula" IF Time Range? THEN CUMULATE(Price) ELSE 0"

 

Hope this helps!

 

Thanks

Akhtar

Highlighted
Super Contributor

Re: How to calculate cumulative results

@takushimozuru 

 

If you want to achieve same result through the Timesum formula then follow the below step:

 

1.  Create a system module to select the " From & To Date"

Screenshot_29.png

2. I have calculated in the same module .

Screenshot_31.png

 

better to create another module without time dimension and use timesum formula.

Screenshot_32.png

 

Note: TIMESUM is appropriate when the result has no time dimension.

 

 

Thanks

Akhtar

 

Highlighted
Certified Master Anaplanner

Re: How to calculate cumulative results

I would use TIMESUM in this case as you aren't looking to calculate in every period which CUMULATE will do. 

 

Here is a link to the Anapedia article for Timesum, the above is correct you will need to convert your From and To dates to periods using the period function and you will need to do this on separate line items as you can't nest period() within a Timesum function 

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/TIMESUM.html 

Highlighted
Contributor

Re: How to calculate cumulative results

Hi,@Akhtar.shahbaz

 

Thank you for your reply.

I was able to get the result I was looking for.

And I understand how to use TIMESUM function.

 

Thank you so much!!

 

Best regards.

Taku