We’re updating how Knack’s equation editor handles the modulo (%) and percentage operators to align with standard mathematical conventions. This change affects the order in which calculations are performed when these operators are used alongside multiplication (*) and division (/).
What’s Changing
The modulo operator (written as “mod” or “%”) now has the same calculation priority as multiplication and division, ensuring more consistent and predictable results.
How This Affects Your Equations:
Before the update: Field1 * Field2 % 5 calculated as Field1 * (Field2 % 5)
After the update: Field1 * Field2 % 5 calculates as (Field1 * Field2) % 5
Example with values:
Field1 = 3, Field2 = 7
• Before: 3 * 7 % 5 = 3 * (7 % 5) = 3 * 2 = 6
• After: 3 * 7 % 5 = (3 * 7) % 5 = 21 % 5 = 1
Action Required
Please review any equation fields in your apps that use the modulo operator (% or mod). If needed, add parentheses to ensure your calculations continue to produce the expected results.
For example: (Field2 % 5) * Field1
Please reach out to Support if you have any questions.