So I am trying to factor in production rates and want to return a percentage based on that rate. The problem is the goal rate varies depending on data in two columns (equipment used, container type).
Column 1 could be:
None
Yes-Deaerator
Yes- RP Filter
Yes- Both
Column 2 could be:
Tote
Fluid...