Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Not applicable

Accumulated Figures??

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*

1 Solution

Accepted Solutions
Employee

Hi,

Take a look at the attachement.

Regards,

Brice

5 Replies
Luminary Alumni

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.

Employee

Hi,

Take a look at the attachement.

Regards,

Brice

Not applicable
Author

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*

Employee

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

Not applicable
Author

Hi there,