Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to convert a Text value to a Number value and be able to calculate the converted value
Hi
Try like below
Num(Num#(urfield, '#,##0;#,##0-'), '#,##0;-#,##0') as urfield
Hello
Try This
if(FindOneOf(FieldName,'-'),'-'&Replace(FieldName,'-',''),Num(Num#(FieldName,'##########0.00'),'##,##,#0.00')) as FieldName
Thanks & Regards,
Huzaifa Momin