Can anyone help me with the following?? I am trying to show a trend arrow for each scenario but think my brackets are wrong.

I have got it to work for other metrics that didnt have the division in them.

Any help greatly appreciated

Rhona

Pick

(Match(ValueList('% of all attendees at ED who are discharged or admitted within 6 hours AMAU registration','% of medical patients who are discharged or admitted from AMAU within 6 hours AMAU registration','% of elective surgical inpatients who had principal procedure conducted on day of admission'),

'% of all attendees at ED who are discharged or admitted within 6 hours AMAU registration', '% of medical patients who are discharged or admitted from AMAU within 6 hours AMAU registration', '% of elective surgical inpatients who had principal procedure conducted on day of admission'),