Solved

FM - A More Elegant Way of Rounding Up?

Posted on 2014-01-17
2
293 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FM - Formatting Merge Fields 4 638
Copy Address, city ,satste zip from one lay out to another 14 104
Job Transaction Field totals 6 60
Simple Search Script in FileMaker 4 89
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

696 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