Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I need help in doing running totals, my expression
sum({<[Term Type]=
,[Year/Month]=
,[Period]={">=$(=YearStart(Period)) <=$(=max(Period))"}
>} COUNT_Pop)
gives me monthly counts, how do I do running totals? Jan, jan+feb, jan+feb+mar, jan-apr so on
Have you considered accumulation option?
not sure why but it is grey out
with the following expression i did get the cumulative sum however it is Nov - Jan , Nov to Feb and so on instead of Jan - Nov. Any ideas on how to reverse order
RangeSum (above(sum({<[Term Type]=
,[Year/Month]=
,[Period]={">=$(=YearStart(Period)) <=$(=max(Period))"}
>} COUNT_Pop),0,RowNo()))
Hi,
you can use Below() function, which is similar to Above() but in reverse order (so in bottom up manner).
Juraj
What is the Format of period.
Did you check Max(Period) format?