2 Replies Latest reply on Apr 1, 2014 9:18 AM by Rochelle Williams

    Simple Calulation returning incorrect results

    Rochelle Williams

      I created a calculated field that takes one number and divides it into another for an example, I'm trying to come up with a Service Level %. I took ([Ans W/SL]/[Offrd])*100.

      This calculation is so simple but results are wrong. I looked at my aggregations and I'm using AVG which is what i want but the result continues to be incorrect. Should i be using a different aggregation to get the simple calculation or am i just out of my mind and need to step back for a minute.

       

      Any help would be great.