sum string attributes

Hello,   I want to do the sum of two string attributes they both have as a content USD 1000 and USD 500 as an example, but when aggreagate sum activity accepts just integers, is there aby other way to take do the sum while the attribute is stored as a string?
1 answers

It depends, if 'USD 1000' as a whole is the string, you first have to make sure that you filter out the text and only the numeric values remain. After that, it's quite simple, use the parseInteger($yourstring) function to turn your string in an integer so you can execute the sum function.


Hope this helps.