2 Replies Latest reply on May 20, 2014 11:12 AM by Claire_2

# calculation for greater than / less than

### Title

calculation for greater than / less than

### Post

Hi,

Using the invoice stater solution in filemaker pro 12. I have a field, type : calculation that I'd like to perform as follows :

if the subtotal is less than \$50, 5% is calculated, greater than \$51, 10% is calculated

the subtotal is the total of all items on the invoice, before tax.

how can I specify the calculation for the above?

thanks

• ###### 1. Re: calculation for greater than / less than

If ( Sum ( InvoiceData::Amount ) < 51 ; 0.05 ; 0.10 )

Picky detail, taking your words exactly, you've specified a value when the total is less than \$50 and when it is more than \$50 but not what value to use when it is exactly \$50. Thus you may need to modify this expression by using < instead of < depending on which percent value you want for total = \$50..

• ###### 2. Re: calculation for greater than / less than

good point!

thanks Phil