Formula to find fractional numbers

Yahoo Archive
1
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
>
2
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!
3
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!








Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(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



_____

YAHOO! GROUPS 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>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]