• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

FM - A More Elegant Way of Rounding Up?

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
rvfowler2
Asked:
rvfowler2
1 Solution
 
Will LovingPresidentCommented:
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
 
rvfowler2Author Commented:
Thanks, read the article, it also helps with other types of rounding.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now