1 Reply Latest reply on Nov 27, 2018 5:52 PM by Jennifer VonHagel

    Calculate Min and Max Value excluding one Area and applying all filters

    Ritu Chandiramani

      Hello,

       

      I need to calculate the Min and Max values for one of the calculated field in the attached packaged workbook. Please refer to sheet HI_Patient_Day Rate Sheet

       

      The Min and Max values will be based on the following conditions:

       

      It should exclude MJR_AREA_NM = 'SCR_OOA'  while calculating the value.

      It to take into account any changes to the filters on the right while calculating the value.

       

      Any guidance will be helpful.

       

      Best Regards,

      Ritu Chandiramani