Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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