Crystal formula
I'm sure this is a simple formula but I can't figure it out
If the amount is greater or equal than 1,500 and less then 4999.99 it should be 5
If the Invoice amount is greater or equal than 5,000 it should be 10
Here what have which only works for the first condition
if {@TotalNet} >= 1500 then 5
else if {@TotalNet} > 5000 then 10
else 0
If the amount is greater or equal than 1,500 and less then 4999.99 it should be 5
If the Invoice amount is greater or equal than 5,000 it should be 10
Here what have which only works for the first condition
if {@TotalNet} >= 1500 then 5
else if {@TotalNet} > 5000 then 10
else 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was easy. Thanks for your help!
else if {@TotalNet} > 1500 then 5
else 0