5 Replies Latest reply on Mar 8, 2013 2:52 PM by Dan Huff

# How do I calculate a new field which is average of two # fields?

I'm new to tableau. I'm trying to write a formula which in excel would simply be "=AVERAGE(A1,F1)"

I've been trying "AVG(,[F1]) but that causes an error. Please, what am I missing? Is this possible in Tableau?

Thank you.

• ###### 1. Re: How do I calculate a new field which is average of two # fields?

Will--

Assuming you want to compute this average within every row of your data, this should get you to the answer you want.

AVG ( [Measure 1] + [Measure 2] )

Hope this helps,

Dan

• ###### 2. Re: How do I calculate a new field which is average of two # fields?

I'm still not getting the desired result... I do want to compute the average within every row, yes. But this is not giving me the result I'm looking for.... "AVG ( [Measure 1] + [Measure 2] )" gives me a new column which is the two values added together.

As an example. I have a row where the two values are 0.354963 and 0.204312

The formula you provided gives me the sum of those two values  (0.55927484) When I am looking for 0.279637

Any other ideas?

Thank you.

Will

• ###### 3. Re: How do I calculate a new field which is average of two # fields?

That is my mistake. What about just creating a calculation that is simply (Measure 1 + Measure 2) / 2 . This should be what you need. Sorry about my misunderstanding earlier.

Thanks,

Dan

• ###### 4. Re: How do I calculate a new field which is average of two # fields?

Yes, I figured that out minutes after posting my followup question and felt very dim.

THANK YOU for your help!

W

• ###### 5. Re: How do I calculate a new field which is average of two # fields?

No worries. It happened to me as well . Also no such thing as a silly question on here. We are all glad to help out.

Dan