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