1 Reply Latest reply on May 28, 2013 2:21 PM by johnmotlagh

    Percentage of total question

    johnmotlagh

      I have a list of support issues around mobile phones that contains about 1.5m records. This is the denominator. I want to come up with an exchange rate calculation.  The numerator is a filtered list of the mobile phones that have some sort of exchange filter associated with them.  This list is about 500k. 

       

      I cannot figure out how to use the non-filtered list as the denominator and the filtered list as the numerator to get an exchange rate percentage.  So the formula would be something like "Filtered Exchange List/Total Number of Support Issues=Exchange Rate%"