Expression with 3 set analysis

[helen_pip]

Hello

I have an expression which has 3 set analysis within it and but it is returning null values (When it shouldn't) and the expression is parsed as O.K.,with no error

Could someone kindly help me write the code correctly, so it will start returning values

=

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

[18_Wks_Admitted_RTT_Return_Wait_Band_Adjusted])

Any help would be very appreciated

[MK_QSL]

count({<  

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

[helen_pip]

Hello

Thank you for your efforts, but the code is not working for me and I get a red error line just under the opening bracket just here:

FactDateNum= {

Any further suggestions would be greatly appreciated

Thanks

Helen

[MK_QSL]

Try this... I missed a comma.

count({<

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

[tresesco]

Does your variable name '53 52 plus' really have single quotes? I guess they are causing your expression parsing not happen properly. You should try without them in the variable expansion.

[antoniotiman]

Sorry Manish,

it is correct >} after  ......plus')'}  ?

[MK_QSL]

count({<

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

or

count({<

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

[helen_pip]

Hello

Can you kindly show me how with the original syntex

Kind Regards

Helen