(1 + 23 + (1 * 22 / 5)) /176 = 0.16...
(SUM(totalSCs) + totalCalls + (TSLdays*WCG/5))/QTCG AS PerCalls
Yep, the parenthesis makes all the difference. Things are not evaluated left to right exclusively. There is an order of operations http://en.wikipedia.org/wiki/Order_of_operations in which things are evaluated. For CF, take a look at the
(the link is for CF9, but I don't believe things have changed at all from prior versions).
Am I writing this incorrectly?
Yes. As BKBK and editcorp mentioned, always use parenthesis to ensure the correct order of evaluation.
Thanks BKBK and everyone else who responded. The parentheses were the key!