Hope you are fine!
I am trying to create a calculated field which will assign the zip's to various colors based on the the category as mentioned above.
currently its showing in correct result as count. the sheet "Master" contain the map where I would like to color code the zip codes on the basis of the category
Hi Somok Sarkar,
Please check the attached screenshot and the modified calculated formula.
the result is still not correct. As per the excel the correct result should be
Count of Zip codes Category 1 when Top 25 by Score =1 168 Category 2 when Top 25 by unit =1 219 Category 3 when Top 25 by unit & Score=1 (shared class) 71 Category 4 when Top 25 by unit & Score=0 (other class) 418 Total 876
as per your modification the result is
Other Class 560 Top 25 by Both (shared class) 71 Top 25 by unit 148 Top 25 by Score 97 Grand Total 876
Hence the apart from shared class(top 25 by both) none of them are correct. Please suggest
I'm totally confused.
You can mathematically get 418, but nobody can categorize out x out as 418.
See below table 418 = 876 - 219 - 168. That's correct as calculation.
But as I said both 219 and 168 already include same in x in (71), and out x out is 560.
there are no way to differentiate 142 (71x2) from 560 as item level.