dbTalk Databases Forums  

Rounding and SUM

comp.databases.filemaker comp.databases.filemaker


Discuss Rounding and SUM in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ursus
 
Posts: n/a

Default Rounding and SUM - 02-12-2007 , 08:28 AM






FM8.5 adv, Win XP

I have used the SUM function to retrieve a total of field with a bunch of
repetions. The function returns values that leave out any zeros on the end.
When the result should be 50,50 it returns 50,5. Equally when the result
should be 50,00 it returns 50.
I have tried adding a round to it : Round ( Sum ( MyRepetitiveField ) ; 2 )
but this doesn't change anything
Any way to avoid this?

Keep well, Ursus



Reply With Quote
  #2  
Old   
Grip
 
Posts: n/a

Default Re: Rounding and SUM - 02-12-2007 , 08:34 AM






Leaving out those zeros is normal behavior for a number field. You'd
be able to store them if you made a text calc field and did some
manipulation. Why would you need them stored?

Now, having them displayed is something else, but that's handled in
layout mode under Format number.

G

On Feb 12, 7:28 am, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:
Quote:
FM8.5 adv, Win XP

I have used the SUM function to retrieve a total of field with a bunch of
repetions. The function returns values that leave out any zeros on the end.
When the result should be 50,50 it returns 50,5. Equally when the result
should be 50,00 it returns 50.
I have tried adding a round to it : Round ( Sum ( MyRepetitiveField ) ; 2 )
but this doesn't change anything
Any way to avoid this?

Keep well, Ursus



Reply With Quote
  #3  
Old   
Christian Schmidt
 
Posts: n/a

Default Re: Rounding and SUM - 02-12-2007 , 09:16 AM



Hello Ursus,

Ursus schrieb/wrote:

Quote:
I have used the SUM function to retrieve a total of field with a bunch of
repetions. The function returns values that leave out any zeros on the end.
When the result should be 50,50 it returns 50,5. Equally when the result
should be 50,00 it returns 50.
I have tried adding a round to it : Round ( Sum ( MyRepetitiveField ) ; 2 )
but this doesn't change anything
Any way to avoid this?
Choose the correct number format for this field.

Regards,
Christian
--
Christian Schmidt | Germany | ChriSchmiLi (AT) gmx (DOT) de
No HTML Mails, please!!
De eene hett 'n Rittergut, de annere ritt 'n Gitter rut.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.