This content has been marked as final.
Show 3 replies

1. Re: Weighted Average Calculation HELP!
Luciano Vasconcelos Aug 22, 2016 12:09 PM (in response to Mikey Michaels)Mikey, how do you get the 82.33 value?
How would be out of Tableau?

2. Re: Weighted Average Calculation HELP!
Naveen Agarwal Aug 22, 2016 12:24 PM (in response to Mikey Michaels)1 of 1 people found this helpfulYou 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

3. Re: Weighted Average Calculation HELP!
Luciano Vasconcelos Aug 22, 2016 12:35 PM (in response to Naveen Agarwal)Fine. It's correct.