Can you explain with a example data?
its percents. if the average percent for Prod is <=40 then its under for everything else if its <=60 then its under. I can't put up a workbook.
Without sample data/workbook it's difficult to find a solution.
You can try below logic if it helps, as its not clear from your explanation which value you want to display when percent meets the criteria.
if avg([percent])<=.4 then "A"
elseif avg([percent])>.4 and AVG([percent])<=.6 then "B"
I have two different criteria that need to be under which is the issue because the <=60 is overriding the the <=40 because its on the same dimension. I have Prod Dev and UA in Environment.
In that case you can first check <=40 in your if statement and then <=60. So if it falls in <=40, It wont go and check in <=60.
if percent <=40 then 'something'
elseif percent <=60 then 'something'