I had this question after viewing need sql CASE statement to replace excel formula
I thought the solution presented fixed the problem, however it did not.
The attached documents show the error messages after a couple different changes to the expression.
I can't find any examples of expressions that add multiple numeric fields after the "THEN" portion of the CASE WHEN expression.
Is this type of statement just not valid?