Solved

FM - Rounding issue

Posted on 2014-01-30
2
214 Views
Last Modified: 2014-02-05
In the following formula, the rouding of the SnowPercent, which is 9.7 still shows 9.7 and thus when I do the PercenttoText custom function it has it as "Nine and 7/100".  How would you do it differently than below to force two decimal places?

PercentToText_cf ( Round ( SnowPercent ; 2) )
0
Comment
Question by:rvfowler2
2 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39822701
You want it to display as "9.70%"  or "Nine and 70/100" ? It seems to me that if the custom function is giving you 7/100 for .7 rather than 70/100, then that's an error in the portion of the function calculation that deals with the decimal.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 39836989
Thanks, fixed it.
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
How do I Test SQL in Filemaker 13? 3 175
FM - Sorting Titles 5 67
FM - Is there Some Calculation for GetValue with a Range? 3 49
Convert Large XML files to CSV 5 1,208
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 is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 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

14 Experts available now in Live!

Get 1:1 Help Now