Are you getting wrong numbers or are you getting an error, red pill etc.?
Tableau will give different results for x/y and sum(x)/sum(y) . If you use the former in an equation with aggregation sum, it will be sum(x/y) which is not the same as sum(x)/sum(y). That would be the first place to look at if your results are not what you expected.
is getting an error shows：unable to blend the aggregate and non aggregate parameters with this function.
calculated field's efficiency has been an aggregation parameters, but calculate field's customer is not an aggregation parameters, both can't use in IF AND iif function.
however, I need to get results by contrast both condition
there for I am looking for other way to deal with
You can't mix aggregates and disaggregates in a calculated field and blended fields always come as aggregates.
Can't you make your fields aggregates e.g. instead of customer='china' try ATTR(customer)='china' or MAX(customer)='china'
Hi Bora Beran
Thank you! It is work. get what I want.