Hello,
Im trying to color coordinate the employee production based on the employee cohort. I have a measure called Work Type, which Im not sure how to incorporate to the formula below, so that the employees production is measured against the average of their assigned cohort.
=if(sum([PPE History.Total Transactions])/sum([Hours Worked])>(sum([PPE History.Total Transactions])/sum([Hours Worked])),Green(),rgb(178,36,36))
