1 Reply Latest reply on Dec 29, 2009 9:38 AM by mrvodka

    Calculation Field



      Calculation Field & or an Input field


      I currently have a sales tax field set up as an input field, i.e. I manually calculate the sales taxes and input that amount.

      Now I would like to set this filed up to either calculate the taxes for me, or if I wish, input the amount manually.

      I know someone knows how to do this, please give me some ideas. Thanks


        • 1. Re: Calculation Field & or an Input field
             A sales tax field should be a number field that also is setup as a lookup. That field should look up the current rate from another table ( such as preferences etc ) that stores the current rate. Due to the fact that the sales tax rate changes, a calc field makes no sense as you would have to change the calculation each time.