dbTalk Databases Forums  

Re: Rounding a price with Lasso 6?

comp.databases.filemaker comp.databases.filemaker


Discuss Re: Rounding a price with Lasso 6? in the comp.databases.filemaker forum.



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

Default Re: Rounding a price with Lasso 6? - 08-03-2003 , 08:22 PM








Jay Valinis wrote:
Quote:
Dear FMPros,

I have a database that is reporting back a price which is all fine and good,
but it's coming back with multiple decimal places, and I am interesting in
rounding this price to the nearest whole dollar.

I've tried:

[Math_Round : [Field: 'Price'], 1.00]

But somehow the double brackets is confusing things. Does anyone know how to
do this?
Write a new calc field in the database that does what you want, then
use that with Lasso.

Cheers

Webko


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.