Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average function giving different result per row

Hi,   I'm trying to get an average from a column but is giving a different value every row. I'm unsure how to find the average for the entire column.   The data source is a salesforce report I c...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I've found the solution. 

    The problem was with how the report was being generated not with the formula.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mussaenda Thanks for the quick reply. Unfortunately it gives the same result as before.

mussaenda's avatar
mussaenda
Community Champion
6 years ago

Strange. Are there any data on your visual from different table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    mussaenda wrote:

    Strange. Are there any data on your visual from different table?

    Just one table is used in this visual.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I've found the solution. 

      The problem was with how the report was being generated not with the formula.

       

       

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi JeanStargir,

        So it seems that  you solve your problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.