Hey Guys,
I have to conditionally change my data using indb tools.
I have data like
cust Quantity Q1 Q2
1 1 2 3
2 5 4 6
3 4 4 6
CASE WHEN "QUANTITY" <Q1 THEN "HEAD"=Q1
ELSE "HEAD"=Q2
*Head is a new column that I want to create
I have tried using the above case statement using indb formula but it doesn't work.I am ok to use any other in db tool as well.
Solved! Go to Solution.
Formula tool for HEAD
IF "QUANTITY"<"Q1" THEN "Q1" ELSE "Q2" ENDIF
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |