Decimal places / Too many zeroes
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
