I get this value from a sheet - R$ 890,00, and I need to use as a Number to group, sum and etc.
But I can’t read it from excel as a number, is there a way to use Format options to identify this as a number and enable this?
Ps: The R$ are the currency symbol for Brazil.
Use Modified JavaScript to remove ‘R$’ then convert into number format using rename field. After this you can perform Number to group , sum and more operations
1 Like
Did that and also removed dots and comma. after that I used a Java command to help:
var Valor = parseFloat (Valor)
then I was able to change it to number using RenameFields and its Formats.
1 Like