Join Slack
Powered by
How can I trigger on the remainder
# general
b
Bakr
02/22/2021, 3:23 PM
How can I trigger on the remainder
d
Dominic B
02/22/2021, 3:44 PM
Haven't got a scenario to test with easily, but I'd look at using a Formula(numeric) highlight condition and something like CASE WHEN ROUND({custcol.field1}/{custcol.field2}) = {custcol.field1}/{custcol.field2} THEN 0 ELSE 1 END greater than 0.
b
battk
02/22/2021, 4:24 PM
MOD
or
REMAINDER
battk
02/22/2021, 4:26 PM
usually mod unless you are doing something unholy with negatives
Open in Slack
Previous
Next