How can i do the following calculation:Values/Fields
are:Amount:[DISCOUNT1] 10[DISCOUNT2] 20[DISCOUNT3]
30Percents:[DISCOUNTIF1] 1[DISCOUNTIF2] 2[DISCOUNTIF3]
3Total:[TOTALDISCOUNT]The calculation should go something like this:If
total amout is over 10[DISCOUNT1] and below 20[DISCOUNT2], the
[DISCOUNTIF1] is 1,If total amout is over 20[DISCOUNT2] and below
30[DISCOUNT3], the [DISCOUNTIF2] is 2,If total amout is over
30[DISCOUNT3], the [DISCOUNTIF3] is 3.