2 Replies Latest reply: Jun 8, 2012 6:35 AM by Dan-Ketil Jakobsen

# Use of before or after function

Hi

I have a pivot table looking like this:

Area201206 201205201204
North93,495,294,7
South92,995,194,9
East93,193,994,5

I now need to add a collumn for each period where I calculate the differense in Index form last period

Area12012062 201205 201204

indexdiffindexdiffindex
North93,4- 1,895,20,594,7
South92,9- 2,295,10,294,9
East93,1-0,893,9-0,694,5

I tried this

=Rangesum(before(column(1),0,(RowNo()+1)))

But this one accumulates values. Tried to alter different parts of it, bus since I do not fully understand what is going on in this formula, I`m just guessing. Wit no luck so far.

Any ideas?

BR

Dan

• ###### Re: Use of before or after function

Hi Dan,

The diff expression should be

```[index] - After([index])
```

Using [index] to refer to the name of the expression.

Hope that helps.

Miguel

• ###### Use of before or after function

Hi Miguel

Simplicity.

Solves my problem.

Thanks!

BR

Dan