Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 03, 2018 03:46 PM
Hello I have a column for my item cost and a column with the sales tax I paid. I want to create a formula in the third column that calculates my cost x sales tax percentage and then add the answer to the cost to get total cost. I did Cost * {Tax %} and get an error.
Jun 03, 2018 04:26 PM
Did you get an #Error
as result of your formula ? Was the result erroneous (not the right result) or the formula did simply not work and you couldn’t save your formula field?
I’m simply asking because there is a bug in calculations with a percent
Jun 03, 2018 04:40 PM
Yes I get an error. my goal is to get the total cost with the sales tax.
Jun 03, 2018 04:50 PM
I quickly tried this formula :
Cost+Cost/100*{Tax %}
Which gave something looking like this :
Was this what you were looking for ?
(The Cost*Tax%
field was just there to verify the math :winking_face: )
The Total Cost
is formatted as “Currency”. The Cost
is /100
To go around the bug with calculations with percentage.
Apr 15, 2020 10:45 PM
Thank you very much this solved my problem
Aug 25, 2020 02:35 PM
Would it be possible to make the percentage vary based on the item belonging to a certain category?
Aug 09, 2022 03:10 PM
I made a check stub for this.
Aug 11, 2022 03:45 AM
Before, I used to do all this work in Excel, but over time, I realized that it is a waste of time and that there are very good alternatives. I already don’t even remember what formulas I use, and that’s why, unfortunately, I can’t help you with this. But instead, I recommend you make a pay stub. All the fees and taxes you pay on an online pay stub will also be calculated there. It is very simple. All you need is a pay stub generator, and within 2 minutes, your pay stub is ready. I recommend you to try it.