Skip to Content
0
Apr 26, 2010 at 04:55 PM

Help on query

22 Views

Hello Someone could give me some advise to write a query for a formated search

We have several conditions to be applied on the field discount percentage

I would like to have a percentage automatically calculated based on the doc total of each invoice

above 500 000 and below 750 000: 3%

above 750 000 below 1 000 000 : 5%

1 000 000 u2013 1 250 000: 8%

1 250 000 u2013 1 500 000: 10%

1 500 000 u2013 1 750 000: 13%

1 750 000 u2013 2 000 000: 15%

What would be the query with conditions for each interval

Thank you