# Calculations / Rounding bug

This topic is 7161 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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?

##### Share on other sites

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

##### Share on other sites

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!

##### Share on other sites

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.

##### Share on other sites

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!

##### Share on other sites

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?

##### Share on other sites

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

##### Share on other sites

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!

##### Share on other sites

This topic is 7161 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Recovery and reopening of FM7 files

By Tony Morosco,

• 3,447 views
• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,094 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 4,923 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,247 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with: