Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to calculate a daily stock.
Below I show an example of the calculation that I need
RangeSum(Above(Count(ticket),0,RowNo()))
or
RangeSum(Above(Total Count(ticket),0,RowNo()))
Here are some other options:
2) Use the Checkbox "Full accumulation" in the charts expressions tab
3) pre-calculate the cumulative value in the script. This way the cumulative value of a specific month doesn't change even if you make selections in calendar.
(Examples in the qvw file below)