Hi,
I have a crosstab with rows that are grouped by month with a total number and I also have to run a Cumulative total or running total for this total number
The report does the correct calculation in the running total but if one month there is no value, the running total in the RT column will show 0 for that month. But if any other Month after this zero value month has a value the report will show the correct running total.
What I need to see is the previous cumulative running totals and not 0 for these zero months
Thanks for any advice or any formula on how to correct this issue.
Thanks,
Please find below an example:
          Jan 1 2 3
running total:1 2 3
        Feb 5 0 2
running total:6 0 5
        March :7 1 5
running total:13 3 10

For Feb I need to see the running total as 2 rather than 0

I did find a solution. I added the running total to the cross tab. Then I added an embedded summary column and for this columns calculation formula used the following:

local numbervar i;
local numbervar temp;
for i:=1 to CurrentRowIndex do
temp:=temp + GridValueAt (i, CurrentColumnIndex, 0);
GridValueAt (0, CurrentColumnIndex, 1)+ temp

Then I suppressed the field showing the running total. I shrunk this column so the user would not have known it was there. I had to suppress the column grand totals in the crosstab as the embedded summary gave the wrong value there but this was OK for the purpose of the report I was writing.

Hope this helps.

Edited by RoadRunner - 05 Nov 2019 at 10:37pm