Expression not interacting with Master Calender

[helen_pip]

Hello

I have an expression which is not interacting with my master calender

The part of the expression which needs to interact with the master calender is here:

{$<FactDateNum ={">=$(=v_Start_Date_18_Wks_Admitted)<=$(=v_End_Date_18_Wks_Admitted)"}>}

and the entire expression is:

=count({$<FactDateNum ={">=$(=v_Start_Date_18_Wks_Admitted)<=$(=v_End_Date_18_Wks_Admitted)"}>}
{<[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted]={'53 52 plus'}>}
[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted])

At the present time, my expression shows all of the count, and does not change when I change the values on the master calender

Any help would be greatly appreciated

Thanks

Helen

[alexandros17 · Accepted solution]

The correct sysntax is this:

=count({$<FactDateNum ={">=$(=v_Start_Date_18_Wks_Admitted)<=$(=v_End_Date_18_Wks_Admitted)"},
  [18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted]={'53 52 plus'}>}
[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted])

Let me know

[helen_pip]

Thanks for your help

This is now interacting with my master calender

Thanks

Helen