Budget t/m a period

[francisvandergr]

I have a problem in a chart table. I attached the file. So you can see i have a year budget of 120 on the grootboek 0020 Gebouwen. This means that my budget per month is 10 euro.

When i select period 1,2,3,4 i wanna see in the column 'Budget t/m 4' the value 40. This is not. Can someone help me ?

Thnx

Francis

[#2 · Accepted solution]

Hi,

try

Sum ({<BOEKJAAR = {$(=max(BOEKJAAR))}>}BUDGET2010) / 12 * GetPossibleCount(PERIODE)

as formula for "Jaarbudget"

The idea ist, get the budget, divide by 12 and then multiply by the selected and available fields of PERIODE.

Hope that matches your needs.

BEst regards

Michael

[francisvandergr]

Thnx Michael ! GetPossibleCount is a good function. I can use it very often.

[francisvandergr]

Thnx Michael ! GetPossibleCount is a good function. I can use it very often.