Decimal places / Too many zeroes

[djkhalif]

Good morning all,

I've looked through past posts and googled to find this but nothing comprehensive. This is my statement:<cfoutput query="queryname"> =sum(#defective# / #units#)%</cfoutput>. I am getting too many zeroes after the decimal. For instance, 6 / 105 =  0.0571~ however; my results look like this: 0.000571~. I need to remove the additional zeroes. Has anyone had this problem? If this helps, the output is MS Excel.

Thanks in advance,

djkhalif

[djkhalif]

Good morning all,

I found the problem. Because the % symbol was showing in my results, that lead me to realize it was being used as part of the function. When I removed it,%, the results showed as they should.

Thanks again,

djkhalif