Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Francis,
I think you are very close to the solution:
sum( {<VPeriode= { "<=$(=max(VPeriode))" } >} amount)
This is syntax-checked with my fields "VPeriode" and "amount"
HtH
Roland
may be try somthing like this
sum({<Year={2011},Rubriek = {'02.02.02'},Periode = {"<=$(=maxPeriode))"} >}amount))
sorry this gives result '0'. Is maxPeriode good not something max(Periode)
Hello Francis,
I think you are very close to the solution:
sum( {<VPeriode= { "<=$(=max(VPeriode))" } >} amount)
This is syntax-checked with my fields "VPeriode" and "amount"
HtH
Roland