Formula to find fractional numbers

Perfect... I could quite get this in Crystal... but dumped it into
Excel and used the formula and achieved the desired report! That was
a HUGE time saver! Thanks!

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> YourNumber - INTEGER(YourNumber) > 0 means some fraction. Not sure
if INTEGER is the exact function in Crystal but something like that.
BAQ...no clue.
> -Todd C
>
Does anyone know how to write a BAQ or crystal report formula to find
only fractional numbers? For example, I want to have a report of all
my inventory that is not a whole number. If I have .25 of something,
or 10.58 of something, I want those part numbers. Anything with
numbers to the right of the decimal!
YourNumber - INTEGER(YourNumber) > 0 means some fraction. Not sure if INTEGER is the exact function in Crystal but something like that. BAQ...no clue.
-Todd C

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of how2wow
Sent: Tuesday, April 11, 2006 4:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Formula to find fractional numbers

Does anyone know how to write a BAQ or crystal report formula to find
only fractional numbers? For example, I want to have a report of all
my inventory that is not a whole number. If I have .25 of something,
or 10.58 of something, I want those part numbers. Anything with
numbers to the right of the decimal!

(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

_____

* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>