>I have a stocknumber for each product similar to BR(number)-stuff. I need to extract (number) from the stocknumber shown in a drop down for use in a mathematical expression with a value in another. What expression should I use to do the extraction?
>
>Thanks,
>JD
This is help on the extraction part only:
Given what is above: val(substr(stocknumber, 3)) will return you a number. How you do the rest of it, I have NO IDEA! :-)
--Todd Sherman
-Wake Up! Smell the Coffee!