All values till a period

[francisvandergr]

I have a question about set analyses. I have a field "amount" and the fields "year" and "period" and "Rubriek". What i want is when i select period in a listbox that QV calculates with all values till that period. I have my calculated field in a Textbox. And i want only records with rubriek 02.02.02

This is my formula :

sum({<Year={2011},Rubriek = {'02.02.02'},Periode = {'<=$(Periode)'} >}amount))

The problem is now QV give values of all periods and not only <= the selected period. When i select 9 i want all periodes till 9, and not for example period 10 and 11

Can someone help me ?

[lironbaram]

may be try somthing like this

sum({<Year={2011},Rubriek = {'02.02.02'},Periode = {"<=$(=maxPeriode))"} >}amount))

[francisvandergr]

sorry this gives result '0'.  Is maxPeriode good not something max(Periode)

[#4 · Accepted solution]

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