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.

Accepted answers

anand.shekhawat

@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

All comments

anand.shekhawat

@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

bhubeshrana

There is no formula for your situation.

Just Add the lineitems and devide by no of line items

jimfeng5

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

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…