Change Data using Indb tools

[rats]

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.

[Inactive User · Accepted solution]

Formula tool for HEAD

IF "QUANTITY"<"Q1" THEN "Q1" ELSE "Q2" ENDIF