using If condition for showing status of a Region by sales.

[fahimazizi60]

I want show the Good,Bad,Fair from by comparing the Region wise sales with the minimum and maximum value in table 1.

i am using this expression  but its not working.

=if(Classification ='Fair' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Fair',
if(Classification ='Bad' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Bad',
if(Classification ='Good' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Good',0)))

[Gysbert_Wassenaar · Accepted solution]

See attached qvw