Conditional function

[BillyL14]

Could someone please advise on what is wrong with this function?

Thank you very much

[JosephSerpis]

Hi @BillyL14 try removing the quotes around 0. You only put quotes if the column you are testing in a text field not a numeric field.

[bpatel · Accepted solution]

hi @BillyL14 ,

you could also try this formula. removing the quotes and changing [stat.value]==[inv.value] to [inv.value]. since you are updating the column you don't want the [stat.value] ==

i hope this makes sense!

[vizAlter]

@BillyL14  — You are giving a condition after the "Then" phrase which is not allowed. Please see the highlighted error in the screenshot.

Solution is here --- Assuming that "0" is a string/text in your data (not a numeric data type):

IF [Stat.value] = "0" THEN [Inv.value] ELSE [Stat.value] ENDIF