New Contributor

## How do I get the average of a line item?

I have Line Item A, Line Item B, Line Item C, and Line Item D. How do I get the average of those line items? I know I could add them and divide 4 but I was wondering if there was a formula? I tried the average formula but I don't think it works in this case.

1 ACCEPTED SOLUTION

Accepted Solutions
Valued Contributor

## Re: How do I get the average of a line item?

Sum all the line items and divide it by the number of line items. This is the only way we have to find the average of the line items.

~Anand

3 REPLIES 3
Valued Contributor

## Re: How do I get the average of a line item?

Sum all the line items and divide it by the number of line items. This is the only way we have to find the average of the line items.

~Anand

Contributor

## Re: How do I get the average of a line item?

There is no formula for your situation.

Just Add the lineitems and devide by no of line items

Certified Master Anaplanner

## Re: How do I get the average of a line item?

Create a "Count =1" line, and instead of divide by 4, you divide by the sum of the "Count =1" line.