Error in Formula

[francisvandergr]

Formula below gives an error

=sum( {$<Periode = >}, Grootboeknummer = {7190}>} Grootboekmutatiebedrag)     What i want is :  the sum of Grootboekbedrag for all periods before the selected period and only from grootboeknummer 7190.

How can i get this ?

I hoop to hear !

[erichshiino]

Hi, try this:

=sum( {$<Periode = {'<=$(=only(Periode))'} , Grootboeknummer = {7190}>} Grootboekmutatiebedrag) 

If it doesn`t work, we need to check the format of the field Period because, sometimes set analysis will not handle a date in a string format very well..

Hope this helps for now...

Regards,

Erich