9 Replies Latest reply: Jun 16, 2014 2:13 PM by emmanuelle bustos RSS

    Avg() Function

      Hello Guys,

       

      I just want to clarify how Avg() works. The first time I use avg, it is working properly. Giving me the right average like 3.4 or 3.1 etc.

      But I have to include a 'historical' data in my application and boom! The avg goes 'gaga' and my output average goes beyond 800+++!

      Even if I click year 2013, my average computation is 700! Why did it went like that? How do I find/resolve this problem?

      Can you guys give me how it works? Anyone can explain?

       

      Thanks a bunch!

      Donna