How can I get Crystal to ignore decimals? 1

[crysma]

Hi,

I've been working on a reoport where the records will be grouped by the field intAverageExp. For the purpose of this report only, I'd like to get crystal to ignore the values after the decimal point and treat this as a whole number. Thus records with a value of 3.1, 3.2, etc would all be grouped together under 3.. Is there anyway to get crystal to do this, or will I have to use an access query? Thanks in advance,

Sheryll

 

[synapsevampire]

Try:

Truncate({table.value})

-k