giszzmo (4/30/2014)
It looks like it works! Thank you so much! Can you explain to me why you use SUM instead of MIN?
Because MIN will not obey 0, -1, 1 order
If the dataset contained entries for all three values (true, false and NULL) you would have values 1, 0 and -1 and MIN would return -1 not 0 as you wanted
*Edited*
if you want to use MIN then you would have to use the values 1, 2 and 3 in the correct order and change the indicator ranges
Far away is close at hand in the images of elsewhere.
Anon.