Addition with substring

daveschultz

Well Known Member
I have an rtf template where I need to take the first digits of a numeric data element and add the together (i.e if the value is 123 I need to add 1+2+3). I am able to substring out the digits, but then I can't add them, because it doesn't see them as numeric. Any ideas on how to do this?

Thanks

Dave
 
You have to convert them to numeric/mathnumeric and then add them . There are functtion to convert. Search for ConvertString* and you should be able to find one.

Chan
 
oh i saw this is in BI thread so not sure if its E1 or BI related?.

Chan
 
I was able to get this working using substring instead of substr.
 
Back
Top