Here is what I am trying to achieve:
I have a column with this 2014-NNNN/XXT
I need to extact the number part (NNNN) and increment with nearest multiple of 10. So for instance if the number is 5010, the result should 5020. But if the number is 5016 the result should also be 5020.
Up until now, I have only be able able to extract the number by using 2 calculated columns: one with the RIGHT function in order to remove 2014- and the LEFT function acting on result to remove /xxt.
I now need to increment with a multiple of 10, as previously explained.
Any assistance would very appreciated.