The CEIL function does what you're looking for<br><br>4.5 CEIL() Performs the ceiling function, which given any<br> number, returns the next greater integer.<br><br> Syntax<br>
a = CEIL(num_expr)<br><br> where num_expr is the given number, and a is the resulting value.<br><br> Return value<br> A field of the same type and length as num_expr.<br><br>
Notes:<br> If the given number is already an integer, the original<br> number is returned.<br><br><br><br><div class="gmail_quote">On Fri, Feb 17, 2012 at 4:27 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <span dir="ltr"><<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I have a processing set that needs to count the number of records selected<br>
and then divide by '10'<br>
Suppose the number of records is 73 - so my processing divides by 10 and<br>
the result is 7.3<br>
<br>
I need to round up to the next whole number....so I need the resulting<br>
answer to be '8' in this case<br>
(meaning anything above a number should round up to next number, even if it<br>
was 7.1, etc - it should round up to 8)<br>
<br>
Trying to determine how to write an edit for this or is there already<br>
something inherent in filePro that will round up but doesn't require it to<br>
be 7.5 or higher to round up<br>
Hope that makes sense ha<br>
<br>
Any suggestions?<br>
<br>
Scott<br>
PDM<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20120217/3be32c17/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20120217/3be32c17/attachment.html</a><br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div><br>