Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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