TOTAL% COLUMN

RobNY2

RobNY2

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

Dale Murphy

@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

RobNY2

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