IF function - error

[BillyL14]

Hi 

Could someone tell me what is wrong with my formula?

Thanks

[ChrisTX · Accepted solution]

Remove the double quotes around [Inv.value]

You are trying to update the value in the existing field Stat.value, which is a data type Double

Is field Inv.value also a Double?

Chris

[atcodedog05 · Accepted solution]

Hi @BillyL14 ,

Change the formula to

if [Stat.value] = 0 THEN [Inv.value] ELSE [Stat.value] ENDIF

It will work. Its a datatype issue

If this solves your task please mark the post as solution.

[BillyL14]

@atcodedog05 @ChrisTX thanks

[atcodedog05]

Happy to help 🙂