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.