Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a problem to calculate a cumulative sum.
My database contains 18 months of data, so it is in 2 years (2015 and 2016)
I wish, when I select ONLY the month of April, the amount displayed is the sum of January, February, March and April.
Sum({$<[Temps Arrete] ={">$(=yearstart([Temps Arrete])) <=$(=[Temps Arrete])"}>}[Montant Loyer])
First problem:
With this formula, the selected month is not included in the sum
(Example: if I select April, I get the sum of January, February, March)
Second problem:
When I click in December 2015 and January 2016, the sum between 2015 and January 2016 is always calculated, or it is a sum of the year I need. How should I do it to say that the sum ends in December?
Thank you for your response
Perhaps this blog post can help you: Relative Calendar Fields
If not an As-Of table might help: The As-Of Table & Calculating rolling n-period totals, averages or other aggregations