• 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.