1 Reply Latest reply on Mar 29, 2016 10:54 AM by kyle.taylor.2

    Finding percentage of numbers that start with 'x'

    kyle.taylor.2

      I have created a 'if startswith' calculation to separate pools of integers, however I am having a difficult time figuring out how to calculate a percentage based off of these numbers. For example, taking the following numbers:

      4965138

      2851667

      1565159

      7456321

      4915348

      2861501

      1285531

       

      I need to calculate how many of the numbers fall into a category that is represented by the first 2 digits, in this case 49 and 28. 


      Any ideas of the best way to do this?  I was going to create a 'hazmat' 'non-hazmat' calculation and try to determine the percentage that are hazmat based upon the true/false scenario but I cannot find a way to make it work.