Shot in the dark @tjaffer because I think both ways should work, but I always do my case statements like "case when {type}='Invoice' then (case when {appliedtotransaction.type}='Sales Order'...etc".