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:
| Code Block | ||
|---|---|---|
IF(ColumnNumber=1,GrossSales,"") CASE ColumnNumber WHEN 1 THEN GrossSales END | ||
| Page Properties | ||
| Author | |
| Contributors | ||
| limit | 1 | |
| showLastTime | true | |
| reverse | true | order | update
Answer
The correct way is to use IF:
| Code Block |
|---|
IF(ColumnNumber="1", GrossSales, 0) |
ColumnNumber is text, so use "".
GrossSales is money, so you can't use "", instead use 0.