1 Reply Latest reply on Nov 13, 2009 4:57 AM by djkhalif

    Decimal places / Too many zeroes

    djkhalif Level 1

      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,