Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My actual data set is the monthly values, and I want it to be the result is the cumulative values, Can someone enlighten me what expression or how to do it just like the cumulative values
Hi Step,
The used of function AGGR() may help. See below:
Aggr(RangeSum(Above(Sum(Value),0,RowNo())), (YearMonth))
or see attached QVF for reference.
Regards,
Bill
Maybe like this
Rangesum(above(sum(sales),0,Rowno()))
Hello Arulsetto,
there is no effect on commulating column, must be 2018 from jan to dec they must be summing up then from 2019 it will cumulate the sum values of 2018 to 2019
Can you share sample app with expected output
This is the sample data:
This is the expected result:
Hi Step,
The used of function AGGR() may help. See below:
Aggr(RangeSum(Above(Sum(Value),0,RowNo())), (YearMonth))
or see attached QVF for reference.
Regards,
Bill
Thank you sir Bill for a solution!