Average two numbers from separate columns

I want to average two numbers from separate columns to create a new final rank column. I'm sure there is an easy way to do this but I can't come up with it for some reason. See sample data below

Miles Volume Final Rank

100 1,200 650

50 500 275

600 75 337.5

I am also wondering if I can use a weighted average to weight miles more heavily (70%) than volume (30%).

Any assistance is greatly appreciated.

Thanks!

Data Investigation

Accepted answers

Maskell_Rascal

Hi @nwatzlaf

You can use the formula: Average([Miles],[Volume])

To get to a weighted average, you can add in a calculation to to the above formula. Something like the below:

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

All comments

Maskell_Rascal

Hi @nwatzlaf

You can use the formula: Average([Miles],[Volume])

To get to a weighted average, you can add in a calculation to to the above formula. Something like the below:

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

nwatzlaf

Hi @Maskell_Rascal ,

Thank you!! I think I just made a syntax error. I did not know the comma was the separator.

Thanks again!!

vizAlter

@nwatzlaf — Suggest you to keep the same data type for the numeric fields.

Greg_Murray

@nwatzlaf

You want to use this for weighted average. The formula in the solution doesn't look like it's correct. You don't need to average after you apply the weights, just add the results together.

[miles] * .7 + [volume] *.3

Maskell_Rascal

@Greg_Murray is correct. My head was thinking in terms of weighted indexes.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703