4 Replies Latest reply on Dec 27, 2009 9:06 PM by emartek1

    Complex SUM statement giving erratic result! WHY!!!

    emartek1

      This part of my query;

       

      SUM(totalSCs)+(totalCalls)+((TSLdays)*(WCG))/(5)/(QTCG) AS PerCalls

       

      is giving me an erratic result...specifically 24.03 instead of .16

       

      1 + 23 + (1 * 22) / 5) /176 = .16

       

      Am I writing this incorrectly? Any assistance would be greatly appreciated!