How do I get the average of a line item?

zdlee
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
anand.shekhawat
Super Contributor

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

@zdlee 

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

View solution in original post

3 REPLIES 3
anand.shekhawat
Super Contributor

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

@zdlee 

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

View solution in original post

bhubeshrana
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

jimfeng5
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.