Equations

The Ivinex platform currently supports the following mathematical symbols:

• + (addition)
• - (subtraction)
• * (multiplication)
• / (division)
• ^ (exponentiation) or (power)
• % (modulo)

Here are a few examples of how to construct simple equations in Ivinex:

• Equations will only be evaluated when using INTERGER and DECIMAL data types
• Equations are not currently evaluated on import or if an equation input is changed by a workflow
• Addition Example:
  • [Field: shipping_price] + [Field: extra_fee] or [Field: shipping_price] + 4.50
• Subtraction Example:
  • [Field: total_price] - [Field: discount] or [Field: total_price] - 9.95
• Multiplication Example:
  • [Field: contract_price] * [Field: tax_rate] or [Field: contract_price] * 0.065
• Division Example:
  • [Field: total_apples] / [Field: total_people] or [Field: total_apples] / 5
• Exponentiation Example:
  • [Field: my_number] ^ [Field: my_other_number] or [Field: some_number] ^ 3
• Modulo Example:
  • [Field: my_number] % [Field: my_other_number] or [Field: my_number] % 10
    
    

Advanced Equations

More advanced equations are supported in Ivinex.

• Example 1:
  • [Field: room_height] * [Field: room_width] * [Field: room_length]
• Example 2:
  • ([Field: field_one] * [Field: field_two]) ^ [Field: field_three]