How to convert string to number?

[bhaveshp90]

Hello,

I have a table as shown below; When selected Code = 17 the value is showing as 0

For Code = 17, the value is a string which is why my expression is not working.

Sum(Num#(Forecast_Cost_to_Complete,'###,###,###'))

Any ideas how to resolve this?

thanks

[Gysbert_Wassenaar · Accepted solution]

Try adding a format for the negative numbers into the format string: =num#('(1234,12)', '#,##0.00;(#,##0.00)' , ',' , '.' )

[sujana1621]

Try this sum(num#(replace(replace(Forecast_Cost_to_Complete,'(',''),')',''),'####')

[bhaveshp90]

thank you gwassenaar‌. It worked out. slight change I have removed '.' and is working well.

=Num(Sum(Num#(Forecast_Cost_to_Complete,'###,###,###;(###,###,###)' , ',')),'###,###,###,###')

[aolaleye]

Thanks for sharing this tip. 😁It solved my problem and all my numbers showed on the report. It seems they were initially stored as strings