rounding up to next number

[Ian Wood]

The CEIL function does what you're looking for

4.5      CEIL()             Performs the ceiling function, which given any
                            number, returns the next greater integer.

          Syntax
                a = CEIL(num_expr)

          where num_expr is the given number, and a is the resulting value.

          Return value
               A field of the same type and length as num_expr.

          Notes:
               If the given number is already an integer, the original
               number is returned.



On Fri, Feb 17, 2012 at 4:27 PM, scooter6 at gmail.com <scooter6 at gmail.com>wrote:

> I have a processing set that needs to count the number of records selected
> and then divide by '10'
> Suppose the number of records is 73 - so my processing divides by 10 and
> the result is 7.3
>
> I need to round up to the next whole number....so I need the resulting
> answer to be '8' in this case
> (meaning anything above a number should round up to next number, even if it
> was 7.1, etc - it should round up to 8)
>
> Trying to determine how to write an edit for this or is there already
> something inherent in filePro that will round up but doesn't require it to
> be 7.5 or higher to round up
> Hope that makes sense ha
>
> Any suggestions?
>
> Scott
> PDM
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20120217/3be32c17/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120217/aba1549c/attachment.html