Summary All Data Until Date Selection

Previous Member

Hi,

 

How to sum all data until date selection?

 

Example:

 

Data on DB From 01/01/2014-01/12/2018 (dd/mm/yyyy)

 

And i want to sum Data where day 01/05/2018.

I try sum data with function "yearly cumulate" but report just shown data sum 01/01/2018-01/05/2018.

I want report shown sum 01/01/2014-01.05/2018.

 

Thanks.

 

Unknown

Hi Wahyu Nugraha,

  The cycle property is a useful time function here. When doing life-to-date calculations, I set cycle=10000. That will give me the life-to-date for the appropriate time period. In your example, where day is 01/05/2018, using cycle=10000 would return a sum of the last 10000 prior days. Using this in combination with Detail by Year and/or Previous Year, we can add previous full year values. 

Previous Member

Hi Bob Gill,

 

Thank for your solution. This solution hepful.