How do I Group Select on value of less than whole number

[cinbh]

We are using Crystal 8.5 on VFP 8.0 platform. Our orders are to be shipped in what we call full trays (or whole numbers). An order is made up by a number of detail items, so all we care about are the orders whose TOTAL of these detail items does not end up in a whole number value. So my example is:
Order # TotalTrays ShipDate
54853-2 8.5 2/28/05
36024-1 105.5 1/3/05
58290-1 20.0 3/4/05
64302-4 110.5 5/6/05
So within the group select I will need to find all but #58290-1

Any help is greatly appreciated.
Cin

 

[Turkbear]

Hi,
If TotalTrays is a field in the data then perhaps:

 truncate({TotalTrays}) <> {TotalTrays}

as the Group select formula would do it..

 

[cinbh]

Thanks for the quick response TurkBear. Worked like a "charm"!!

 

[Turkbear]

Hi,
Thanks..
No problem...
(Since we get what we give,helping others is actually selfish )