asked on # 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

DatabasesCrystal ReportsSQL

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

That was easy. Thanks for your help!

else if {@TotalNet} > 1500 then 5

else 0