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