TOTAL% COLUMN
Best Answer

Dale
I figured out the solution:
=AVG(INDEX({Values for Equip Range 1}, MATCH([1st Equip Order Status]@row, {Values for Equip Range 2}, 0)), INDEX({Values for Equip Range 1}, MATCH([2nd Equip Order Status]@row, {Values for Equip Range 2}, 0)))
Thanks for trying to help me!
Rob
Answers

@RobNY2 I'm not sure what your question is. Are you trying to add together the two percentages? Then you should probably have two columns for the percentage values of the two status. Otherwise you are trying to add two text fields together.
(Adding the % from the two columns doesn't make sense (to me) because you will be over 100% for many conditions. Hence my confusion.)
Can you clarify the intended outcome?
dm

Dale
I figured out the solution:
=AVG(INDEX({Values for Equip Range 1}, MATCH([1st Equip Order Status]@row, {Values for Equip Range 2}, 0)), INDEX({Values for Equip Range 1}, MATCH([2nd Equip Order Status]@row, {Values for Equip Range 2}, 0)))
Thanks for trying to help me!
Rob
Help Article Resources
Categories
Check out the Formula Handbook template!