Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please see attached. I need to add an additional column which will show the year to date Actuals and the remaining Budget. So for
Aug 2017 1925+250=2175
Sept 2017 1925+250+280=2455
Oct 2017 1925+250+280+300=2755
Nov 2107 1925+250+280+300+125=2880
Dec 2017 1925+250+280+300+125+155=3035
Any idea on what the correct expression should be to achieve the above?
Thanks
see attachment
Hi Tim,
I think there is a misunderstanding. I wanted to get the Actual Year to Date figure + Remaining Accumulated Budget figures in another column. Your expression is accumulating the budget figures.
Thanks
ok have a look at this.
regards
tim
Thanks Tim,
Works out fine.