I have a field that I want to break out, something like value [0760-0780] so I can run calculations on those fields. The ranges can be massive, so using a traditional lookup isn't really ideal.
I can't seem to find a logical way to do this, any suggestions are welcome.
So i was able to break out the values so they are just ranges 01-10. Just unsure how to actually map that to values now. Maybe I'll try a lookup, as it looks like it only goes to 1024, but that seems cumbersome.