How do I use Datamart IF condition in SQL Expression?

Question

I would like to calculate a field according to a value of another field in the Datamart but am unable to do so. What is the correct expression?

I tried:

Answer

The correct way is to use IF:

• ColumnNumber is text, so use "".

• GrossSales is money, so you can't use "", instead use 0.