How to convert text to string and sum

[john_henry]

I have a field from a QVD that is text and I want to convert it to a number and sum it.  I'm using the following syntax in the load script, but is not working:

sum(num#("Header Net Value in USD"))

[MayilVahanan · Accepted solution]

Hi @john_henry 

Suppose, it contains any symbol like "$", then mention the number format in Num# function and try it out

Ex: Sum(Num#("Header Net Value in USD",'$#,##0'))

[john_henry]

thanks @MayilVahanan !  It works