Simple Math Not Working... Loosing my Mind

Building this system that i’m using to generate Estimates and Invoices for my Clients. Very simple design. this is a screen that allows me to enter a new item to the estimate. The yellow fields are user input, the blue fields are calculated inputs. The calculations of the blue fields make NO Sense. Super simple math. So here’s the details and some screen shots:

User Input Fields:::
QTY: User enters the quantity of the item they need to add to the invoice
Unit Cost: User enters the amount we pay per unit from the vendor
Unit Sale Price: User enters the amount we sell the item for before Sales tax is added

Calculated Fields:::
Total Cost: QTY’s Value * Unit Cost’s Value
Total Sale Price: Total Cost’s Value * QTY’s Value
Unit Sales Tax: Unit Sale Price’s Value * Drop Down Sales Tax Value’s Value
Total Sales Tax: Total Sale Price’s Value * Drop Down Sales Tax Value’s Value
Total Unit Sales Price : Unit Sale Prices’s Value + Unit Sales Tax’s Value
Grand Total Sales Price : Total Unit Sales Price’s Value * QTY’s Value

Here’s the Screenshot of what i get…

In this case im using a test item where one QTY has a cost of 5.21 There for at a QTY of 2 i should get 10.42 for TOTAL COST… Then a Sale Price of 20.31 Per Unit and again at a QTY of 2 I should have a TOTAL SALE PRICE of 40.62… Now for the funny business. It calculates Sales Tax perfectly. and the TOTAL UNIT SALE PRICE Comes to 21.99 (Unit Sale Price + Unit Sales Tax = TOTAL UNIT SALES PRICE)
And Even calculates GRAND TOTAL SALES PRICE as 43.98 Which is correct. BUT! Total Cost and Total Sales Price (two lower left blue fields are not nearly correct…

Here’s my Field’s and their “Initial Content Settings”…
QTY:


UNIT COST:

UNIT SALE PRICE:

UNIT SALES TAX:

TOTAL COST:

TOTAL SALE PRICE:

TOTAL SALES TAX:

TOTAL UNIT SALES PRICE:

I’ve been messing with this for many hours and thought maybe Bubble was having issues. but that doesn’t seem to be the case. As always thank you all for your help and your time!!

a very quick glance - if you format an input it switches it to text and therefore will no longer work as a decimal

2 Likes

Thanks Simon, I just tried to change. i got rid of the Formatting in the Field. Same Result…

Going off of your Idea Simon, I changed all fields to Currency and removed formatting. this is now working perfectly. Thanks for leading me in the right direction buddy. greatly appreciate it!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.