Cumulating budget automatic per month

[#1]

Hello you all,

I want to divide a budget into 12 months so I''ve created an inline table. The year budget is 500.000 and now I want to calculate this per month wit a cumulating calculation. So for example:

LOAD * INLINE [

Month Monthname calculate

2010-01 Januari 0,084931507

2010-02 Februari 0,161643836

2010-03 Maart 0,246575342

2010-04 April 0,328767123

2010-05 Mei 0,41369863

2010-06 Juni 0,495890411

2010-07 Juli 0,580821918

2010-08 Augustus 0,665753425

2010-09 September 0,747945205

2010-10 Oktober 0,832876712

2010-11 November 0,915068493

2010-12 December 1

];

Januari must be calculated like 500.000 * 0,084931507

Februari like 5000.000 * 0,161643836 and so on. December wil be 500.000 * 1 = year end (this is the easy part), but now I want the system to know what month it is without selecting a month manualy. For example: It's November so I want the system to calculate 500.000 * 0,915068493 = 457.534,25 (cumulating budget untill this month)

Can anyone help?

[googel84]

I'm not sure of having got your message but I'll try.

First of all align Monthname column to the list of month names set into MontNames variable. Then, set a trigger that selects in Monthname field the value calculated with month(today()).

Hope it helps.