Set analysis with Between and excluding Nulls

[adamdavi3s]

I can't figure this one out, i've tried many combinations but obviously not the magical correct one:

I have tested the field which is len=0 when null and the chart is seeing it as a null not a missing or 0

let v_variable='count({< EndDate={">='&'$'&'(=WeekStart)<='&'$'&'(=weekend(WeekStart))"}-{''}>}DISTINCT Code)';

let v_variable='count({< EndDate={">='&'$'&'(=WeekStart)<='&'$'&'(=weekend(WeekStart))"},EndDate-={''}>}DISTINCT Code)';

let v_variable='count({< EndDate={">='&'$'&'(=WeekStart)<='&'$'&'(=weekend(WeekStart))"},EndDate-={"null()"}>}DISTINCT Code)';

[adamdavi3s · Accepted solution]

Free floated the calendar and appears to be OK now so sticking with that!