How do I use Datamart IF condition in SQL Expression?

Owned by Lukasz Wiktor (Deactivated)
Last updated: Aug 02, 2022 by Jan Panoušek
1 min read

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:

IF(ColumnNumber=1,GrossSales,"") CASE ColumnNumber WHEN 1 THEN GrossSales END

Answer

The correct way is to use IF:

IF(ColumnNumber="1", GrossSales, 0)

  • ColumnNumber is text, so use "".

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

Found an issue in documentation? Write to us.