Fuzzmaster
New Member
Trying to return the value of an expression or zero if the expression is negative. I thought this would work:
Anyone have a working method? Reasons why this method doesn't?
Code:
GREATEST(((ROUND(INV.MerchAmt) - 1)*0.12),0)