0

Calculating Sales Tax

This is such a simple formula, I don't know why I am unable to figure it out.

 

I have 3 fields, a dollar amount (Price) field, a percentage field (Tax), and a calulcated field.

I am trying to calculate the sales tax in my calculated field. For example, if the Price is $1.00 and tax is 6%, I want to calculate the total to be $1.06

 

I've tried Price+Tax, but the return is $7.00 ? 

2 replies

null
    • Tacho
    • 5 yrs ago
    • Reported - view

    A percentage field doesn't exist! It's still a number field.
    Add another calculated field TAXAMOUNT. The formula for this should be like:

    -----
    Price * Tax / 100
    -----

    The calculated field for the TOTALAMOUNT would then be:

    -----
    Price + Taxamount
    -----

    • SMoore
    • 5 yrs ago
    • Reported - view

    Thank you so much!

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1377Views