Using average in dataview

Options
Previous Member
Previous Member
5 Up Votes First Comment 5 Likes First Anniversary
edited April 2020 in Platform

Does anyone know how to use average in dataview and get the grand total to average not sum when there are more than one row sort.

 

Grand total average error

Answers

  • Etienne CAUSSE
    Etienne CAUSSE Customer
    First Anniversary Advocate Community Voices Name Dropper
    Options

    Hi Ash Wilks, what is it you're trying to achieve ? A standard average or a weighted average function ?

  • Peter DeGregorio
    Peter DeGregorio Customer
    First Comment 5 Likes First Anniversary
    Options

    It seems like your "h" is already an average so its summary algorithm probably should be calculate not average

  • Daniel Zillmann
    Daniel Zillmann Active Partner
    First Anniversary Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board Photogenic
    Options

    I agree with Peter, you should set the summary algorithm to "calculated", that should give you the right result.

Categories