This content has been marked as final. Show 2 replies
I'm trying to do a win/loss analysis and want to figure out the best way to determine wins, loss, DQ.
The data looks like:
Competitor Name Status Distinct (Opp ID) Win/Loss rates
Comp A Won 673 %
Comp A Lost 221 %
Comp A DQ 425 %
I assume the best way is to create an if/then expression that returns won, lost or dq but I don't know how to have it show as a percentage vs. a #.