6 Replies Latest reply: Feb 20, 2011 8:45 AM by rsondak RSS

    Calculation result not as expected

      Hi All,

      This is my first post, so be easy on me. :-)

      I have a strange probleem that I think should be solved quite easily.

      I have the following data as an example:

      ID length

      1 180

      2 345

      3 180

      I tried the following expression in a textbox:

      1. sum(length) = 705 <= correct and as expected

      2. count(length) = 3 <= correct and as expected

      3. avg(length) = 0.16319444 <= incorrect, expected 705/3 = 235

      4. sum(length)/count(length) = 0.16319444 <= incorrect, expected 705/3 = 235

      What should I do to get the correct value '235' ? I dont quite understand why it calculates 0.16319444 instead of 235.

      Thank you in advance.