Calculating Average of two coloumns out of three

building reports webintelligence
1

Hi,

Need some quick help please. Lets say I have three columns that are measures(lets say different $ amounts), how can I omit the third column and calculate the average of the first two colums only? using a formula or something? Please advise.

Thanks,
Amit

amitmishra4 :us: (BOB member since 2007-11-05)

2

Hi Amit,

Not sure if this is what your looking for but if you just want a column to display the average or say col A and col B then this example formula should work: =Sum([col A] + [col B]) / 2 . The third column should not matter if it’s in your table or not.

Joe Szabo :us: (BOB member since 2002-08-19)