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

Managing record access for multiple data levels

Formula URL - Edit then Add

Create a formula duration over 5 years

Looking for State abbreviation to full spelling formula

Using multi select field in pipelines

Recent Discussions

Back to basics: Pulling info from a grand-parent table

File Attachment Field in Pipelines

Can I use quickbase actions within the same table?

Question about relationships

Reports & Charts - Managing Client-Specific Name Visibility