Solved

FM - A More Elegant Way of Rounding Up?

Posted on 2014-01-17
2
291 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 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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…

810 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