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

# Weighted Average Calculation- HELP!

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 • ###### 1. Re: Weighted Average Calculation- HELP!

Mikey, how do you get the 82.33 value?

How would be out of Tableau?

• ###### 2. Re: Weighted Average Calculation- HELP!

You will need to setup a calculated Field to actually calculate the Weighted Average.

Looks like you want to have a weighted average of the open days.

You can first create a Field to calculate the Product of Open Days and Extended Payment Terms - Current

[Weighted Average]*[Extended pymnt terms - Current]

Then you can use this field to calculate the WeightedAvg

SUM([ProductTermsWtAvg])/SUM([Extended pymnt terms - Current])

Here is how you can plot the two at the same time 1 of 1 people found this helpful
• ###### 3. Re: Weighted Average Calculation- HELP!

Fine. It's correct.