Accumulated Figures??

[#1]

HI there,

I want to include the budgeted figures next to our Actual figures for Comparison.

But the table (information) that I pull from out System accumulates the figures.

i.e. For the month of July it only gives me the month of July's figures. But the budgeted figure for August is July plus August.

September's budget is then September plus August (July and August) and so on.

Can someone please help me with a formula, either in the back or front-end. So if I want August it should Take August and subtract July??

Thanks

*R*

[simondachstr]

rangesum(before(sum(Budget),1,ColumnNo()))

This should give you the accumulated total budget sum for each month up to that date. Not sure though if it's the cleverest way to solve that.

[Brice-SACCUCCI · Accepted solution]

Hi,

Take a look at the attachement.

Regards,

Brice

[#4]

Hi Brice,

Thank you...the formula that you attached works perfectly.

Only thing now is my new field called Budget now shows July (which is my first month) now shows a big amount and then the rest shows per month??

Thanks

*R*

[Brice-SACCUCCI]

You need to know the value for June if you want to get the value for July. Indeed, the idea is to substract the accumulated value for month N-1 to the accumulated value of month N to get the value for month N.

Then, if you want to compute the value for June, you'll need the value for May, etc.

If you don't have this information, I don't see how you can get the value for July .

Brice

[#6]

Hi there,

I see what your saying.

Will see if I can get the June figure somewhere.

Thanks

*R*