Number conversion format

[SH_94]

Hi community,

I have the error as per below message and would like to ask what is the impact if i dun solve it and how to solve ?

Many thanks for the helps.

[ShankerV]

Hi @SH_94 

This might be due to many scenarios.

For example, if you are trying to save the output as Int32 or Int64 if the result achieved is Double.

If you are able to share screenshot of Formula (21), can understand the issue further and let confirm whether it will have any impact or not.

Many thanks

Shanker V

[SH_94]

Hi @ShankerV ,

Kindly find the original file below for your refernece. Is there anyway to change it to double format ?

[binuacs]

@SH_94 One way of doing this

[ShankerV]

Hi @SH_94 

One ways is to use Select tool to change the Datatype.

Many thanks

Shanker V

[OllieClarke]

Hi @SH_94 you're getting those conversion errors because you have values in the column you're converting to a number which are just hyphens. They'll be converted to nulls, which is what I presume the hyphen means. 

If you want to make them 0 instead then use a formula like:

Tonumber(If [Field]='-' THEN '0' ELSE [Field] ENDIF)

Hope that helps,

Ollie