Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to ask how it's possibile to obtain a new calculated measure (called "TREND") that is obtained this way:
1) if the row for the month in "VALORE 2021" is not 0 then it's equal to "BUDGET PESATO" * "DELTA % SUL MESE" both for the month where this condition is true
2) if the row for the month in "VALORE 2021" is 0 then the value is obtained for this month by multiplying "BUDGET PESATO" of this month and "DELTA % SUL MESE" value of the latest month when "DELTA % SUL MESE" was different from zero.
Thanks a lot.
Perhaps this?
Sum(Aggr(If([VALORE 2021]<>0, "BUDGET PESATO"*"DELTA % SUL MESE",
If([VALORE 2021]=0, RangeSum(Sum({<MESE={$(=AddMonths(Max({<"DELTA % SUL MESE"={"=Sum("DELTA % SUL MESE")<>0"}>}MESE),-1))}>} "DELTA % SUL MESE"),Sum({<MESE={$(=Max(MESE))}>} "BUDGET PESATO"))), DIPARTIMENTO))
Thanks a lot but I solved differently using nested above and if.