I have 3 reports printing for wholesale and retail customers
When printing for wholesale everything is fine

When printng for customers however, the OrderSum field (using a Dsum command) shows an error, even though the individual costs are all calculated correctly. In the relevant form it shows up just fine, it's the report that get's the error

I can only imagine that the problem is because the retail price is coming from a calculation and not a direct input
I input my wholesale prices directly without VAT in the table
However for retail, I input the final price and then I have another field where it removes the VAT with a calculation.
Then in the OrderQ I have a Price field that runs an IF command that basically says if customer is Wholesale, get wholesale price, but if customer is retail get the retail-no-vat-calculated price
But since the form is fine, I don't know wy it's not working in the report. I used the exact same command. Help!