Formula says Invalid type Operator

Question

I am new to creating workflows and I am getting an error when trying to change values in the same column. The result should be for amounts that are equal to or greater than 100 that the value should be 100 and if it is below 100 then it should be for the same amount. I tried this formula but keep on getting an error.

if [CLAIM_AMOUNT] >="120" then [CLAIM_AMOUNT] "120" else [CLAIM_AMOUNT] endif

binu_acs · Accepted Answer

@roige_28

if [CLAIM_AMOUNT] >="120" then "120" else [CLAIM_AMOUNT] endif

JosephSerpis · Accepted Answer

Hi @roige_28 if your column/field claim amount is a numeric data type then you don't need to put quotes around 120 and can delete claim amount for the then part argument of the If formula. You only need quotes for string arguements and not numeric.

if [CLAIM_AMOUNT] >=120 then 120 else [CLAIM_AMOUNT] endif

flying008 · Accepted Answer

Hi, @roige_28

FYI.

Min([CLAIM_AMOUNT], 120)

OR

IIF([CLAIM_AMOUNT]>= 120, 120, [CLAIM_AMOUNT])