Mysql Calculation and View as Currency PHPrunner

138.92 / 12 = 11.57666666666667
Shouldn't it be 11.58?? That's how I would always calculate it.
Using Decimal 11,2 will give you 11.58 as it rounds.

@BillyB,
is spot on, the result of this division is 11.57(6).
If you want it to be consistent you need to round it up or down right in the SQL query. Check round() function:

https://www.mysqltutorial.org/mysql-math-functions/mysql-round/

This all makes sense but if it indeed should round to 11.58 , it would make the case cost $138.96 which now becomes the wrong case cost instead of $138.92. Which in turn throws off all the calculations of other fields.
I did not show the whole query but here is another part of it
SELECT

flditemID,

branddesc,

size,

fldcommodity,

division_name,

minbottle,

case_cost,

bottle_post,

case_post,

packed_qty,

(case_cost/packed_qty) AS bottle_cost,

((minbottle - (case_cost / packed_qty)) / minbottle) 100 AS gross_profit,

IF(size = '750ML', ((case_cost/packed_qty)/25.36), 0) AS 750OZ,

IF(size = '750ML', ((case_cost/packed_qty)/25.366),0) AS 750Glass,

IF(size = '750ML', Round(((case_cost/packed_qty)/25.366)4), 0) AS 750Sell, / This is suggested sell price by trade standards/

IF(size = '750ML', (((case_cost/packed_qty)/25.366)4), 0)- IF(size = '750ML',((case_cost/packed_qty)/25.366),0) AS 750profit,
IF(size = '1.5L', ((case_cost/packed_qty)/50.72), 0) AS 15OZ,

IF(size = '1.5L', ((case_cost/packed_qty)/50.726), 0) AS 15Glass,

IF(size = '1.5L', Round(((case_cost/packed_qty)/50.726)4), 0) AS 15Sell, / This is suggested sell price by trade standards /

IF(size = '1.5L', (((case_cost/packed_qty)/50.726)4), 0)- (IF(size = '1.5L',((case_cost/packed_qty)/50.726), 0)) AS 15profit,
IF (size = '750ML' , ((case_cost/packed_qty)/25.366)/ (((case_cost/packed_qty)/25.366)4),0) 100 As Glassper,

IF (size = '1.5L' , ((case_cost/packed_qty)/50.726)/ (((case_cost/packed_qty)/50.726)4),0) * 100 As GlCstper,

UPC

From..............
This is premature as I just saw this reply and I must be misunderstanding something . Will have to investigate.and the other a third party mobile application result in $11.57.???





_I pull the import in a CSV file , from SAP and it runs Mysqlimport.exe from a batch file and ( Task Scheduler ) and imports into MySQL which in turn PHPrunner picks it up. But PHPrunner is running my query as I show above with the incorrect result.
_I need for the query to match what a ( MAJOR ERP SYSTEM SAP )Shows as 11.57 as I have to be consistent with the connected software . How can I achieve this? I am now thinking to moving all these calculations to before list record processed if that is better or even Javascript onload . Any help appreciated.

I'm not sure but maybe you are looking for this. There are a few examples that will not round in this post. https://stackoverflow.com/questions/3833137/how-to-make-number-format-not-to-round-numbers-up

Thanks ,

I looked at something similar earlier today , I think I will test

[color="#303336"]floor function

I still recommend doing it in MySQL to avoid any potential inconsistencies. If you need to round it down use TRUNCATE() function:

https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_truncate

This did it.
Truncate((case_cost/packed_qty),2) AS bottle_cost,
Thank you Both for the help.