Convert into value

[johnlauridsen]

Hi

I have a table from Axapta with values entered into a "text/value" field.

in my script I have the following line...

if(TAXGROUP='K00', EO_CREDITINSURANCE,(EO_CREDITINSURANCE*1.25)) as Insurance,

The field I have as text is the EO_CREDITINSURANCE - is there a good way to convert this to a numeric field?

/John

[jagan · Accepted solution]

Hi,

Try using Num() Or Num#(),

if(TAXGROUP='K00', Num(EO_CREDITINSURANCE),(Num(EO_CREDITINSURANCE)*1.25)) as Insurance,

Hope this helps you.

Regards,

jagan.