So something like, case when (case when type = SO then total else null end) > (case when type = invoice then total else null end) then blah blah blah...? we assumed that wouldn't work, but I'll give it a go