Livoa LogoLivoa
Start
ISNULL(MAX(st.[Summary Condition]), 'C') = 'N'?
ISNULL(MAX([Summary Condition]), 'C') = 'D'?

ISNULL(MAX([Summary Condition]), 'C') = 'X'?

Result = 'C'

Result = 'C'
Result = 'C'
Result = ISNULL(MAX([Summary Condition]), 'C')
End

test

by fikri

0
0 uses