How convert string to number for sum()

[#1]

Hi every body! I

I need your help for this issue..

I got the field "COSTO_TOTAL_OBRA.RPM_ITEM_D" with the values 20 and 29.670,00 but when I do the sum(): sum(COSTO_TOTAL_OBRA.RPM_ITEM_D) the result is: 20 (Object text in the image)

I think that the trouble is that "29.670,00" its a string in place of number, but I don't know how convert this string to number and that then the app shows me the correct result (29.690,00)

I attach the script!

Thanks in advance!

Agus

[kaushiknsolanki]

Try this,

=num(Num#(COSTO_TOTAL_OBRA.RPM_ITEM_D,'#.###,##',',','.'))

Regards,

Kaushik Solanki

[#3]

Thanks a lot Kaushik !

[#4]

Hi, i supose that your problem is in the separators.

See that you amount is the point (.) and the decimal separator is comma (",").

See example below:

Sumatoria:

LOAD sum(Codigos) as Codigos

FROM

(ooxml, embedded labels, table is Sheet1);