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



      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