Hihi,

I’m maybe struggling with the format or formula and would like some assistance if at all possible.

Perhaps I have the formula setup wrong?

I have a few fields

Order Quantity (Number)

Product Cost (Currency)

Product Markup (Percentage)

Product Price (Formula)

(Sumproduct(Product Cost$,Product Markup%)+Sum(Product Cost$)

Total Product Price

product(Product Price, Order Quantity)

In the example:

Order Quantity 50

Product Cost $1.50

Product Markup 15%

Product Price formula is correct and outputs $1.73 (instead of 1.7250)

When I hover over $1.73 it shows $1.725 (USD)

However, when I do the total product price, it outputs $86.25 which derives from($1.50 + 15% = 1.7250)

Instead of 1.73 * 50 = $86.50

I’ve made the format currency with 2 decimal places on all the currency fields, however this issue is still occuring.

Any suggestions would be greatly appreciated as it’s been frustrating

I’ve included a copy of the doc here that’s editable: