2 Replies Latest reply: Jan 29, 2010 12:49 PM by Julien Bruchon

# Cumul inverse

Hi all,

I can't figure out how to write the right expression to get a cumul inverse, that is to say a total sum minus cumulated numbers.

In my file, I've got customers who were billed from 0 to n months ("n" is still evolving). Thus there are X customers matching with 0 bill, Y with 1 bill ....Z with N bills .

I'd like to see graphically the following expression:

for month 0 = Total sum

for month 1 = Total sum - customers Month 0

for month 2 = Total sum - (customers Month 0 + customers month 1)

....

for month N = Total sum - (customers Month 0 +.... + customers Month N-1)

Julien

• ###### Cumul inverse

Hi Julien,

I hope I have understood your requirement correctly. You could use the following expression

=TextCount(Total Customer)-rangesum(above(TextCount(Customer),1,rowno()-1))

For convinience, I have attached an example as per my understanding of your data model.

Nimish

• ###### Cumul inverse

Hi Nimish,