invalid argument when using IF statement on global variable

Options
yesitsmeoffical
yesitsmeoffical Registered Posts: 15

Background:

In prepare recipe I created an "if, then, else statement", inside this statement, one of the "then" condition is to set a field to a formula, where this formula itself is another "if statement" that references to a global variable.

Here is the syntax:

Field_A = (formula): if(${global_var} == 1, 'Y','Nxxxxxxx'), where this global_var is currently assigned to an integer value of 0.

Formula is shown as valid inside the "if, then, else statement", however an error message popped out when I tried to save the entire recipe.

Here is the error message:

An invalid argument has been encountered : Incorrect formula: 'if(${global_var} == 1, 'Y','Nxxxxxxx')' : Missing number, string, identifier, regex or parenthesized expression (Parsing error at offset 3), caused by: ParsingException: Missing number, string, identifier, regex or parenthesized expression (Parsing error at offset 3)

Operating system used: win 11


Operating system used: win 11

Answers

Setup Info
    Tags
      Help me…