Year To end of currently selected month

[Anonymous]

I'm trying to modify a set analysis (in a text box) to count entries from the beginning of the selected year until the end of the currently selected month. I keep getting it up to the current month. How can I modify this expression to basically say Month<=GetCurrentSelections(Month).

When I try that I get '0' when I select Feb and the total should be 135 - although it's entirely possible that I haven't got the syntax right.

Jan=129

Feb=106

Mar(so far)=18

The expression that works for the current month is:

='Year To Date' &Chr(10)& Count({<Month=,Outcome-={"DCI","DCNI"}>}FullCode)

Any pointers in the right direction would be gratefully received.

QV v12

[tresesco · Accepted solution]

May be something inline with:

Count({<DateField={">=$(=YearStart(Max(DateField)))  <=$(=Date(Max(DateField)))"}, Month=,Outcome-={"DCI","DCNI"}>}FullCode)