Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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