Set Expression

[shamitshah]

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

[zhadrakas]

see attachment

[shamitshah]

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

[zhadrakas · Accepted solution]

ok have a look at this.

regards

tim

[shamitshah]

Thanks Tim,

Works out fine.