I'm trying to calculate how many units is within our frames for turnover %. What I would like to accomplish is that data is aggregated on country level as % of positive answer to total number of units. On a unit level you should be able to see unit result. The span is 5-25%
Country: number of units in span/total number of units within a country
Unit: If in span display 'In span', else 'Not in span'
I tried this but it's not correct result. In my test data I have a unit1 in span (22%) and unit2 not in span (30%). The formula should show for a country 50% and if an user select unit1 then 'in' and for unit2 'not in' if both - nothing.