Problem with YTD Average Cumulative calculation

francy8326 — Sun, 15 Mar 2020 13:34:18 GMT

Hi all,

I calculated a YTD average cumulative value grouped by month_year that it is represented as the last day of the month.

(ex. 29/02/2020).

The problem is that when I filter a date month, for example 29/02/2020, I see only the value relative the date selected, while I would like to see also the average cumulative value to January 2020.

The formula I used is:

(RangeSum(Above(sum({< tipo_misura={'Cessazioni'},date_month={"<$(=Addmonths(max(date_month),+1))"},Year={"$(=max(Year(date_month)))"},date_month=>} valore_misura), 0, RowNo()))
/Max(Num(Month(date_month))))*12

Can anyone help me?

Thanks a lot

Francesca

topic Problem with YTD Average Cumulative calculation in App Development

Problem with YTD Average Cumulative calculation