Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 427
  • Last Modified:

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
0
Gerhardpet
Asked:
Gerhardpet
  • 2
1 Solution
 
SharathData EngineerCommented:
if {@TotalNet} >= 5000 then10
else if {@TotalNet} > 1500 then 5
else 0
0
 
SharathData EngineerCommented:
Or

if {@TotalNet} >= 5000 then10
else if {@TotalNet} >= 1500 then 5
else 0
0
 
GerhardpetAuthor Commented:
That was easy. Thanks for your help!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now