2 Replies Latest reply on Apr 27, 2018 6:06 AM by Jim Dehner

    Weighted Average at Summary Level

    Andrew Lemon

      Hi All,

      I have a bit of an urgent request that I hope someone can help me with.

      On the attached, I'm trying to calculate the weighted average discount for each segment based off the invoice price measure. My thoughts were to bring Segment to the row and then invoice total discount % to text.

      This gives me an average; however, this is not weighted average. My invoice total discount field is the discount on a particular invoice, what I'm after is the weighted average based on invoice prices for the entire Segment.

       

      Any ideas as to how this can be accomplished?

      Any and all help is much appreciated!

       

      Cheers!