Wrong RoundUp->RoundDown

Hello @toto146,

You can use the following operation instead:

PREC(ROUND(fieldname21*0.5,0.01),2)

PREC(fieldname21*0.5, 2) is quivalent to the javascript code: (fieldname21*0.5).toFixed(2)

Best regards.

Hello @codepeople,

thanks for your fast reply. I’ve tried the new formula but now the result for the example in the opening thread

What I need is the correct round like in this example:

161,95€ * 0,5 = 80,975€ -> cff rounds down to 80,97€ -< I need the correct rounding to 80,98€

Using the new formula makes out of 161,95€ * 0,5 = 81,00€.

What can I do?

Kind regards
Thorsten

Hello @toto146,

Are you sure that the equation was included using the second parameter in the ROUND operation?

I’ve tested the equation with the structure I sent you in the previous ticket and the number 161.95, used in your example, and the result is 80.97

Please, look the screenshot visiting the following link:

https://wordpress.dwbooster.com/customdownloads/2018/07/13/screenshot_equation.png

Best regards.

Hello @codepeople,

I’ve tried this in console also but my result you can see in the attachment. Crazy.

Hello @toto146,

The second parameter of the “ROUND” operation was included in the latest updates of the plugin, so, I guess you are using a previous version of the plugin on your website. Please, update your copy of the plugin and try again.

Best regards.

Hello @codepeople ,

now after an update the result from

PREC(ROUND(161.95*0.5,0.01),2) is 80,97.

But this is still not the result that I need.

161,95 / 2 = 80,975 -> this must be rounded up to 80.98.

Reaching a 5 should round up to the next full result. E.g. 20,255 = 20,26

Thanks in advance,
Thorsten

Hello @toto146,

The operation: ROUND(80.975,0.01) is equivalent in basic javascript to:

Math.round(80.975*100)/100 = 
Math.round(8097.5)/100 = 8097/100 = 80.97

as you can see, unfortunately the Javascript engine rounds the number 8097.5 as 8097 and not 8098

The alternative is a simple trick:

Modifies your operation as follows:

PREC(ROUND(161.95*0.5+0.000000001,0.01),2)

The sum does not affects the operation, but solves the ambiguity.

Best regards.

Hi @codepeople,

that was the trick!!!

Thanks!

Best regards
Thorsten