Multi level formula

Question

I want to calculate the NFL QB Passer Rating, but not sure best way to do this.&nbsp; Here is the explained process:

Formula 1:&nbsp;Take the completions/attempts, subtract .3 and multiply the result by 5.
Formula 2:&nbsp;Take the passing yards/attempts, subtract 3 and multiply the result by .25.
Formula 3:&nbsp;Take the touchdowns/attempts and multiply the result by 20.
Formula 4:&nbsp;Take 2.375 minus the result of interceptions/attempts multiplied by 25.

After calculating each of the four formulas, there is one final formula required to generate your passer rating:

NFL Passer Rating&nbsp;= The sum of the results of Formula 1, Formula 2, Formula 3, and Formula 4 divided by 6. That result is then multiplied by 100.
------------------------------Mike McCartney------------------------------

mikemccartney · Answer

I believe I got it:((((([Pass Comp]/[Pass Att])-0.3)*5)+(((([Pass Yards]/[Pass Att]))-3)*0.25)+((([Pass TD]/[Pass Att]))*20)+(2.375-(([Pass INT]/[Pass Att]))*25))/6)*100------------------------------Mike McCartney------------------------------

austink · Answer

I know you got it figured out but for readability you might consider doing the formula in another way. It helps to not nest things in some many parenthesis. You probably do not even need all of the ones I included below but experiment with that. Sorry if there is a mistake below but it is more to show how to make the formula easier to read for others or even yourself in the future.

var number passCompletions = (([Pass Comp]/[Pass Att])-0.3)*5;
var number passYards = (([Pass Yards]/[Pass Att])-3)*0.25;
var number passTD = ([Pass TD]/[Pass Att])*20;
var number passINT = (2.375-([Pass INT]/[Pass Att]))*25;

($passCompletions + $passYards + $passTD + $passINT / 6) * 100

mikemccartney · Answer

This is great Austin.&nbsp; Thank you!------------------------------Mike McCartney------------------------------

Forum Discussion

Multi level formula

3 Replies

Related Content

If Then Else formula with a multi select field.

Multi-Select Fields with Commas in Pipelines

Managing record access for multiple data levels

syntax help with formula

Multi-level group/sort not showing subtotals