calculate with variable

[francisvandergr]

=sum(if(Dagboek\Code='69' and $(Begindatum) < Voorraadmutatie\Boekingsdatum,Voorraadmutatie\AantalBij))

I made a variable called 'Begindatum' . What do i want. On my dashboard i want to fill in a Begindatum. It is a field date. And he has to count when Dagboek =69 and Begindatum< Voorraadnutatie\Boekingsdatum, then i want a total of Vooraadmutatie\AantalBij.

I do something wrong it seems. Because i get always the same Total. The variable Begindate dom't work.

[Anonymous]

Try without $():
=sum(if(Dagboek\Code='69' and Begindatum < Voorraadmutatie\Boekingsdatum,Voorraadmutatie\AantalBij))

[francisvandergr]

I've tried that already. It doesn't work. I attached an example. As you see the column "counting" shows always 427. It must depends on the variable

[#4]

your variable seems to be working fine, take out the code field from your count expression and things chop and change ... i suggest you play around with the expression a little, also a slider or calendar object will force the formatting of the value input into your variable. .. hope this helps