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.
That should read "I need to calculate the percentage of numbers that start with 49 or 28". I cannot edit my post - thanks!