Hi team, do you know the correct formula to convert a negative value to zero?
I created a custom field and set up a workflow to auto-calculate the value in the Invoice record using the formula below, but it didn't work. When I tried entering an amount, the field kept blinking, and I couldn't proceed.
CASE WHEN nullif({custbody6},0) - nullif({custbodymac1_},0) < 0 THEN 0 ELSE nullif({custbody6},0) - nullif({custbodymac1_},0) END.
Thank you.