How to use piping with if/then/else statements

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)