2 Replies Latest reply: Oct 30, 2015 12:35 PM by Jonathan Poole RSS

    Percent of column calculation

      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 #.

       

      Any ideas?