number field Formatting in CR2008
I have a column in crystal report which can display both float values as well as integer values...
Using formatting i set the decimal notation as 000.000 it is working fine for float.. but for integer values also it displays decimal part (like 5.000) I want it to be displayed like an integer 5
Any options available in reports/??
Also I need to take an average of a column excluding zero or null values...is it possible?
I tried it is not available..
Thanks in advacne