# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Contributor II

## Average

Dear all

I would like to set the average column equal to average of column(3) (ie \$677.59), kindly advise how to write the formula.

Thank you

Tracy

2 Solutions

Accepted Solutions
Honored Contributor

## Re: Average

try this:

avg(Total Price*Quantity)
Honored Contributor

## Re: Average

No, you are not missing anything. You just cannot use column function in this case!
The Column() function operates on a strictly row-by-row basis.
You will have to use the proposed formula in order to achieve your output!

hope this helps!
3 Replies
Honored Contributor

## Re: Average

try this:

avg(Total Price*Quantity)
Contributor II

## Re: Average

Dear Frank_Hartmann

Many thanks for your quick response.

Kindly advise why avg (total column(3)) is not working as it is the same as avg(total Price*Quantity).

Also, how to make avg(total column(3)) work, am I missing anything ?

Thank you

Tracy

Honored Contributor

## Re: Average

No, you are not missing anything. You just cannot use column function in this case!
The Column() function operates on a strictly row-by-row basis.
You will have to use the proposed formula in order to achieve your output!

hope this helps!