subtraction of 2 records

[#1]

Hi

I need to substract two values of 'Volume' within the following table depending on 'Date' but have no clue how to do that

The logic should be: 'Volume' of maxString(Date,1) - 'Volume' of maxSting(Date,2) [here 20'000-10'000]

Date Volume
30.06.2009 5'000
01.07.2009 10'000
03.07.2009 20'000

Has anybody an idea how to do that?

Many Thanks!!

[#2 · Accepted solution]

Hi,

see the attached example (Quantity - Above(Quantity))!

Good luck!

Rainer