If statement with 2 conditions and set analysis syntex

[helen_pip]

Hello

I have an If statement which is not working and require some assistance, as I want to return a value where the month_end_breach_risk_6wks is either

'2) No date' or 4) Dated - end of month breach'

The statement is:

Count

({<data_source_diag={'In', 'Out}>} If(Match(month_end_breach_risk_6wks('2) No date', '4) Dated - end of month breach'), ur_number)))

The error appears to be around the ('2) No date', '4) Dated - end of month breach'), ur_number))) part of the statement

I have tried set anlaysis and I now know that I cannot use set anlysis instead as thd outcome of this statement requires to remain static when the user makes selections

Any help would be greatly appreciated

Thanks

Helen

[kaushiknsolanki]

Hi,

     Try this.

Count

({<data_source_diag={'In', 'Out},month_end_breach_risk_6wks= {"2) No date","4) Dated - end of month breach"}>}ur_number)

Regards,

Kaushik Solanki