Thank you for the reply. I've tried this syntax but the 'value' is not calculating as the max value, it's returning the value as it was. Could it be because the max value is often the 'not this condition' condition and the where statement is excluding it from the resultant dataset?
... View more