convert from text to number

[Paknanarn23]

I want to convert a Text value to a Number value and be able to calculate the converted value

[MayilVahanan]

Hi

Try like below

Num(Num#(urfield, '#,##0;#,##0-'), '#,##0;-#,##0') as urfield

[mominh_uzaifa]

Hello

Try This

if(FindOneOf(FieldName,'-'),'-'&Replace(FieldName,'-',''),Num(Num#(FieldName,'##########0.00'),'##,##,#0.00')) as  FieldName

Thanks & Regards,

Huzaifa Momin