generate montly records from yearly values

[#1]

Hi

I have budget values for accounts for a year but need to report actual versus budget on a monthly basis.

Thought it would be easiest to create monthly budget values for displaying

Started with something like

Budget_Month:
LET vMonat = 0;
Do while vMonat < 12
load account, (budget / 12), date(addmonths(Year,$(vMonat)))
resident budget_year;
LET vMonat = $(vMonat) + 1;
loop

and tried many variations but did not succeed (Year is '2010')

Thanks for any hint

Juerg

[sparur · Accepted solution]

Hello, Juerg

Please, look at my small example