Skip to main content
Inspiring
November 13, 2009
Question

Decimal places / Too many zeroes

  • November 13, 2009
  • 1 reply
  • 507 views

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

This topic has been closed for replies.

1 reply

djkhalifAuthor
Inspiring
November 13, 2009

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