You can try:
(LOOKUP(ATTR([Team Pythag]),0) - (LOOKUP(ATTR([Team Pythag]),0)*LOOKUP(ATTR([Team Pythag]),1))) /
( (LOOKUP(ATTR([Team Pythag]),0)+
(2*LOOKUP(ATTR([Team Pythag]),0)*LOOKUP(ATTR([Team Pythag]),1))))
With a "Compute using" of 'Team'
Thank you for this formula.
It produces an outcome for one of the two teams. Would there be then a way to produce a figure for the second team as well?
This concept of looking up attributes is definitely new to me and I apologize for what might be simple tasks I am overlooking for the time being.
Further down the line, there are other calculations where I hope to take part of row 1 and part of row 2 as well. While the calculation of win percentage above has a total of 100%, the future calculations I hope to use will not have any base total or sum. For example, I hope to create a "predicted offensive efficiency" total for each team. This will include multiplying team A offensive efficiency by team B defensive efficiency by a national average (TBD figure).
No problem about the ATTR, was only using that because the LOOKUP required some kind of aggregation.
Is the calculation for Team B equal to 1-Team A?
If not, you can use the same formula and just change all the
LOOKUP(ATTR([Team Pythag]),1) to
which will lookup the value in the top line.
Then you can make one Calculated field
IF INDEX()==1 THEN Expected Win % A
ELSE Expected Win % B
So with this approach, you would need to make two calculated fields for every metric,
one for Team A and one for Team B, and then one more piece to say if Team A then
show the metric for Team A, etc.
There are likely more efficient ways to do this.
Matchup Comparison 2.twbx 137.0 KB
That helps, thank you.
Yes, in the case of win% team B would be =1-Team A