3 Replies Latest reply on Aug 22, 2016 12:35 PM by Luciano Vasconcelos

    Weighted Average Calculation- HELP!

    Mikey Michaels

      Quick question - I'm in need of some help!

      On the attached, I need to adjust my AVG[Weighted Average] calculation as this is a a pure average, not a weighted average,  There were only 2 invoices open on this account (seen on the "Invoice level" tab)– one with 79 days terms and the other with 99 day terms.  Tableau calculated 89 days – which is the average. However, the weighted average would be 82.33. 

       

      Any ideas on how to revise?

      Regards,

      Andrew