
1. Re: How do I calculate a new field which is average of two # fields?
Dan Huff Mar 8, 2013 2:27 PM (in response to Will LesherPierson)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?
Will LesherPierson Mar 8, 2013 2:39 PM (in response to Dan Huff)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?
Dan Huff Mar 8, 2013 2:42 PM (in response to Will LesherPierson)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?
Will LesherPierson Mar 8, 2013 2:50 PM (in response to Dan Huff)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?
Dan Huff Mar 8, 2013 2:52 PM (in response to Will LesherPierson)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