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

    Calculation Field

    jeffd

      Title

      Calculation Field & or an Input field

      Post

      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
          mrvodka
             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.