Getting numeric value from a field

[jorkington]

Currently I have a field with data in the format: USD 7.50

I need to use the value in an equation, but am not sure how to isolate the numbers.

[Anil_Babu_Samineni · Accepted solution]

Pleae share different number how you have, If you have for all values in the same format - can be fixed via this?

Num(Num#(SubField(Field, ' ', -1))) as FieldnNew

And then can be used Sum(FieldNew)

[Frank_Hartmann]

Maybe like this:

num#(purgechar(YOURFIELD,'USD '),'##.##')

[jorkington]

Can't test the solution rn, but all values are in the same format: USD ##.##

So hopefully this will work.