How to us Calculated fields

I am trying to use the calculated fields in the workflow and have had some success but I just cannot get the ifThenElse or the greaterThan to work.

I can see from the documentation {greaterThan(parameter1; parameter2)} & ifThenElse(condition; trueBranch; falseBranch)}

What I have is ifThenElse({greaterThan(P0; 6)}; 999; 99)}

P0 is an integer. I just don’t get anything returned if I use the add(P0;99) I get a correct result.

This is how I have set it up

I would be very grateful for some advice



  • Signature {greaterThan(parameter1; parameter2)}
  • Parameters_
    • parameter1: can be any value of any type
    • parameter2: can be any value of any type
  • Description: Determines if parameter1 is greater than parameter2
  • Returns: 1 if parameter1 is greater than parameter2, 0 if not
  • Example call: {greaterThan(3; 3)} returns 0


  • Signature: {ifThenElse(condition; trueBranch; falseBranch)}
  • Parameters
    • condition: logical value
    • trueBranch: any expression
    • falseBranch: any expression
  • Description: Selects one of the two branches depending on condition
  • Returns: trueBranch if condition is true, falseBranch otherwise
  • Example call: {ifThenElse({equal(1; 1)}; 1 equals 1; 1 not equals 1)} returns 1 equals 1

combined example:


1 Like

Thank you much for your assistance I will have a go and see if I can get it to work with the information you have kindly provided