Forum Discussion

Eric's avatar
Eric
Contributor 2
10 months ago

Problem with simple math within Jobber

All these new features are great. but doing simple math correctly would be a much better fix.  I have called in several times over the last 6 months about this simple problem but yet it sill remains.

Start up a new quote.  Put a generic item into the "Product/Service" field.  Now enter a value with an odd cent into the unit price. For example, enter 93.75.  Now enter a partial number into the Qty field.  Example of 3.7.  Now save the quote and see what happens... Jobber will equate the result to $346.88  and it will change your unit price to 93.75135 which is ALL wrong.  Rounding up a partial cent has been a common and legal practice for over a hundred years. Yes, the result was correct but you never change your unit price to satisfy your result.  You just need to simply round up.  If my hourly rate is 93.75 and I worked for 3.7 hours then the result is 346.88, yes, but you should not be changing my hourly rate to 93.75135!  This looks very unprofessional and should not be the way to equate these fields.  This is a very simple math equation and has not been a problem for the last 40 years of personal computers and spread sheets.  Please help me understand why this is still a problem. You NEVER change your source fields in equations to satisfy your end results.  These are simple basic foundation rules for dealing with database fields.  And this is only a simple example of the many many problems I have experienced over the last 2 years with this program.  And many of them still exist to this day.  So frustrating.  Please please please test your product before going live with it.  Get people to test it in the field.  It's very obvious you don't have field testers.

1 Reply

  • jade's avatar
    jade
    Jobber Support Team
    10 months ago

    Hey Eric! Thank you for your question. I’m sorry to hear you have been running into this issue for quite some time.

    I will absolutely submit your feedback to the team, and I’ll also share some insight as to why this happens.

    When the unit cost and quantity are both decimals, Jobber will round so the total amount on the quote only shows 2 decimal places. Using the numbers in the example you gave, with a QTY of 3.7, unit price of $93.75 we get the total $346.88.

    Upon saving the quote, the unit cost does change to 93.75135. Since it’s impossible to pay to 3 decimal places, Jobber will round up that total so it only has 2 decimal places. It then calculates backwards so that the math is clear and accurate. So $346.88 divided by the qty 3.7 will give you the unit cost, which is why we see 93.75135. Since we can’t change the quantity of the unit being sold, Jobber adjusts the unit cost to make it clear what the math works out to.

    I do appreciate and understand your concerns on how this looks unprofessional. We really appreciate the feedback so we can continue to improve!