Calculations / Rounding bug

[schotja]

I'm trying to do a simple calc multiplying 2 fields. Qty X price

Every time i set the price to a decimal say 2.5 it round the total up.

10 x 2 = 20

But 10 x 2.5 = 250

Last version i used was 5.5 and this worked fine... what is going on?

[The Shadow]

I'm not seeing this - can you post an example file that shows the problem?

[schotja]

I think i've narrowed it down to a plugin in the Dacon plugins file.

Doesnt seem to display the same in a file from scratch!

That kind of stuf just erks a guy. SPend hours on a simple issue.

I'll check with them and post their results!

[Ano Nimus]

Here in old 'Yurp' we use commas to separate the digits that Americans separate with full stops, and the other way around:

two and a half = 2.5 in the US, but 2,5 in Europe.

twentyfive thousand = 25,000 in the US, but 25.000 in Europe.

10 x 2.5 would indeed yield 250 here, because FileMaker reads that value as 25, just like when you do 10 x 2,5 in the US.

Maybe FMP or yourself got the separators mixed up? In layout mode, right-click on the field, go to 'number format' and there you find the separators.

[schotja]

Since the plugin is from Germany ( i think) that would make sense. There is a lot of that influence in the field operands but that didnt help. I"ve sent the file to the plugin developer since its' only in their example file that these numbers are rounded up!

WE'll SEE!

[-Queue-]

I'm not quite understanding how 25 becomes 250, with or without a period/comma. Why would FM read 250 as 25? Is the zero an implied decimal?

[Ano Nimus]

25 becomes 250 by multiplying it with 10

If you write 2,5 in the US, it is exactly the same as 25, because the separator (which is meant to separate groups of three digits, as in 25,000 or 1,000,000 for example) makes no sense there, so FileMaker (rightfully so) ignores it. Multiply 25 (or 2,5 for that matter) by 10 et voila

[schotja]

Just a quit update on this. Dacons responded back that it was a formating thing.

Ano Nimos above educated me on the people from "Yurp" and then it made sense how they use commas. But I had already changed the formating thing in their example file. But for some reason it continues to FORCE the rounding functions on numbers containing decimals.

Since i love their plugin so much and all thats already built into the Dacons launchit plugin i just decided for this project that i'd take a crash cours in Fm7 related files. Learned alot but am hoping for input on a diff thread.

Summary: Plugin or example file only forces a rounding that i've not yet found how to undue.

Solution: Use it for its core mechanices and do all the other aspects of job in another related file!