Skip to main content
DCJohnson
DCJohnson
Participating Frequently
May 9, 2018
Answered

Calculate the Tax based on the sum of two other boxes

  • May 9, 2018
  • 3 replies
  • 1994 views

I need a formula to add two boxes (subtotal and other charges) and then times that by the tax rate (which will be input at the point of sale). Can anyone else me write this equation? I am happy to email you my pdf or really anything to get this last step completed. --Thank you!

This topic has been closed for replies.
Correct answer MatLac10492407

Ok, you named at least one of your field wrong.  It is "OtherCharges", not "Othercharges".  JS is case sensitive.

3 replies

M
MatLac10492407
Inspiring
May 10, 2018

This is 90% of errors encountered when facing a simple task.  Always copy/paste field names and variables whenever possible avoid errors.  Sadly (but sometimes helpfully) JS stops as soon as an exception is thrown.  this sometimes helps identify at what place the exception was thrown.

Also, activate the console in case of error.  You can find this option in edition/preference/javascript.  When an error says it can't find a field, it's beacause the name is wrong.

    M
    MatLac10492407Correct answer
    Inspiring
    May 10, 2018

    Ok, you named at least one of your field wrong.  It is "OtherCharges", not "Othercharges".  JS is case sensitive.

    DCJohnson
    DCJohnsonAuthor
    Participating Frequently
    May 10, 2018

    Wow all that because of a c/C. Thank you for all your help, it is so greatly appreciated.

      try67
      Community Expert
      try67Community Expert
      Community Expert
      May 9, 2018

      What's the format of the tax rate field? What are the names of the fields involved?

      DCJohnson
      DCJohnsonAuthor
      Participating Frequently
      May 9, 2018

      I need to sum the "costsubtotal" and "Othercharges" these fields are categorized by number . The tax field is formatted by Percentage, this field is "Taxrate".

      Thank you!!!!

      DCJohnson
      DCJohnsonAuthor
      Participating Frequently
      May 10, 2018

      Yes. Did you change the value of one of the fields, though?


      Yes, I have tried a bunch of different changes, and the CostTaxRate box isn't changing. It is blank.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices