Solved

FM - A More Elegant Way of Rounding Up?

Posted on 2014-01-17
2
289 Views
Last Modified: 2014-01-20
Is there a more elegant way to always round up than what I've done below?

Round (
SizeSqFt * ( TaxPerSqFT / 12 )
+ If ( IsEmpty ( TaxPerSqFT ); 0 ; .5 )
; 0 )
0
Comment
Question by:rvfowler2
2 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39790009
So your goal is to alway have it round up, regardless of how tiny the overage is? For example, if SizeSqFt * ( TaxPerSqFT / 12 ) = 600.00001, you want that to round to 601?

To always round up, use the following:

Round ( SizeSqFt * ( TaxPerSqFT / 12 )  + 0.499999 ; 0 )

See this FM Knowledgebase article for information on the Round() function as well as always rounding up or down.

http://help.filemaker.com/app/answers/detail/a_id/5233/
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 39794290
Thanks, read the article, it also helps with other types of rounding.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Display results of a checkbox set 5 241
Filemaker import xml 3 164
What is the best way to balance this server load? 1 49
View container field on iPad with filemaker go 3 37
Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now