Filter Intergers with Decimal values

[pcollins1]

Hello,
I have a report that contains a formula field in it. I am trying to filter out all records that contain whole integer values that are diplayed form the formula field. If it says 1.00 or 8.00, I want to filter these out, but if it says, 0.92 or 2.83 I want to display these on the report. I was tying to do it via the select expert, but can't figure out how to create the appropriate formula.

thanks

 

[lbass]

Try using a record selection formula like this:

int({@formula}) <> {@formula}

-LB

 

[pcollins1]

Thanks LB worked like a charm!