How to use piping with if/then/else statements

You can easily pipe in a given field’s value for any parameter of an if/then/else statement

In this example, we need to assess whether the value of [gender] is less than 1, if so use that value, otherwise, use a value of 5.

if ([gender]< 1,[gender],5)

For additional assistance, please contact cru@ucalgary.ca