need monthly data---getting accumulate data

[#1]

hello guys,

I need your help around here.

every month I'm getting one file from the users.

(you can see example in the attach files)

the thing is that I need to calculate for every month how much the expenses were but the files

which I receive contain the TOTAL expenses that made untill now.

for ex' (see the attachment ) for ID 'ccc' in month 09/2009 I want to see that his expenses were:

1005-970=35

hope you got me right...

thanx..

[#2]

Hi David,

see the example to get an idea how it could work in a table.

Maybe a step forward.

Good luck!

Rainer

[#3]

well thanks BUT

maybe I didn't mention that , I need

to keep the data into a QVD file at the end and not to calculate it over the GUI.

so for every month I need in addition to the column that contains the TOTAL expenses (untill that month)

another column with the expenses of this month only.

[#4 · Accepted solution]

Hi,

I have modified it and calculate the difference in script.

See the example.

Rainer

[#5]

it seems to be working!

thanx !