Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I need one help. i want to display accumulated data based on selection.
for example if i select 2019-06, it should accumulate value from 2019-01 to 2019-06 and divided by count of year month value in chart. for example:
2019-01,2019-02,2019-03,2019-04,2019-05,2019-06
100,200,400,300,100,200
Total accumulation is 1300 till 2019-06 divided by 6(number of months till selected) expected answer is 216. can any one help me how to write the expression on this
May be this
=sum({$<YearMonth={">=$(=Date(YearStart(YearMonth,0),'YYYY-MM')) <=$(=Max(YearMonth))"}>}Amount)
/
Num(Month(Max(YearMonth)))
see attached
This may help, MTD
May be this
=sum({$<YearMonth={">=$(=Date(YearStart(YearMonth,0),'YYYY-MM')) <=$(=Max(YearMonth))"}>}Amount)
/
Num(Month(Max(YearMonth)))
see attached