Rangesum Before

[marco_puccetti]

Can you explain me the use of rangesum(before()) statement in a pivot table like this:

Tabella
Data older Data newer Value Perc number Percent of increment Value Perc Number Percent of increment

with this formula:

(sum(N_REC)-rangesum(before(sum(N_REC),1,1)))

The formula would compute the increment percentage of the number value related to the Data newer Value number, but i can't understand the meaning.

Can

Thank you

[Gysbert_Wassenaar]

The rangesum does not do anything. before(sum(N_REC),1,1) gets the value of the previous column. The default of the before function is 1 for offset and 1 for number of records. So before(sum(N_REC)) returns the same value as before(sum(N_REC),1,1).

[marco_puccetti]

So to get the sum of the column Value (Data Older) for the column Value (Data newer) is it correct to use 1?

There are 2 columns from column Value (Data Older) to the column Value (Data newer), isn't it?

Thanks!

[Gysbert_Wassenaar]

Yes. The expression should work.

[marco_puccetti]

With 1 or 2? There are 2 columns from column Value (Data Older) to the column Value (Data newer), isn't it?

I expect that it would be used 2 instead of 1 or no?

Can you write me an example to take these values:

Sum (A),

Sum(C)-Sum(A) with before

and the same for  B and D columns?

Tabella
Data older Data newer A B number Percent of increment C D Number Percent of increment

Thanks!