Aug 03, 2018 03:39 PM|PatriceSc|LINK
It's just SELECT Field1, Field2, Field1-Field2 FROM etc...
If you want to use two colums for display purpose and feel uncomfortable with case you could test the full expression for clarity ie :
CASE WHEN Field1-Field2>0 THEN Field1-Field2 ELSE NULL END, -- this column is for positive values
CASE WHEN Field1-Field2<0 THEN Field1-Field2 ELSE NULL END -- this one is for negative values
Or it could be also done client side by exposing additional computed properties...
Edit: if you tried Something that fails it could be better to discuss directly your issue. The syntax for the CASE expression is at