2 Replies Latest reply: Sep 16, 2014 7:30 AM by Rhona Corcoran RSS

    Help needed with brackets to show trend arrow

    Rhona Corcoran

      Hi

       

      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'),

      if((Sum({$<[Improving Inpatient Experience]={2},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={1},ReferredMM={$(#=Max(ReferredMM))>}ActualValue))>((Sum({$<[Improving Inpatient Experience]={2},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={1},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))),'qmem://<bundled>/BuiltIn/arrow_n_g.png',
      if((Sum({$<[Improving Inpatient Experience]={2},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={1},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))<(Sum({$<[Improving Inpatient Experience]={2},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={1},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))),'qmem://<bundled>/BuiltIn/arrow_s_r.png',
      if((Sum({$<[Improving Inpatient Experience]={2},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={1},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))=((Sum({$<[Improving Inpatient Experience]={2},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={1},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))), 'qmem://<bundled>/BuiltIn/arrow_e.png',

      if((Sum({$<[Improving Inpatient Experience]={22},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={23},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))>(Sum({$<[Improving Inpatient Experience]={22},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={23},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))),'qmem://<bundled>/BuiltIn/arrow_n_g.png',
      if((Sum({$<[Improving Inpatient Experience]={22},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={23},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))<(Sum({$<[Improving Inpatient Experience]={22},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={23},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))),'qmem://<bundled>/BuiltIn/arrow_s_r.png',
      if((Sum({$<[Improving Inpatient Experience]={22},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={23},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))=((Sum({$<[Improving Inpatient Experience]={22},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={23},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))), 'qmem://<bundled>/BuiltIn/arrow_e.png',

      if((Sum({$<[Improving Inpatient Experience]={56},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={57},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))>(Sum({$<[Improving Inpatient Experience]={56},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={57},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))),'qmem://<bundled>/BuiltIn/arrow_n_g.png',
      if((Sum({$<[Improving Inpatient Experience]={56},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={57},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))<(Sum({$<[Improving Inpatient Experience]={56},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={57},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))),'qmem://<bundled>/BuiltIn/arrow_s_r.png',
      if((Sum({$<[Improving Inpatient Experience]={56},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={57},ReferredMM={$(#=Max(ReferredMM))>}ActualValue)))=((Sum({$<[Improving Inpatient Experience]={56},ReferredMM={$(#=Max(ReferredMM)-1)}>}ActualValue))/((Sum({$<[Improving Inpatient Experience]={57},ReferredMM={$(#=Max(ReferredMM)-1)>}ActualValue))), 'qmem://<bundled>/BuiltIn/arrow_e.png')))