I am trying to create a view of the running total of records over specific buckets. I have used successfully created the bucketed view (see below). Blank spots = 0s.
The problem occurs when I go to create a new view with the cumulative total over all successive buckets. The calc below was successful in generating the cumulative total, but only for rows with data points in the first column. Rows without data points in the first column are completely blank, despite having values further down the row. See especially FA15/FA16/FA17.
How can I ensure that the cumulative total is calculated for those rows without data points in the first column? Thanks.
I was not able to open your attached file, but you can First Fill Blanks with 0 either using ZN(Your Calc)
and then try Commulative Sum