Convert into value

johnlauridsen — Wed, 27 Jun 2012 09:50:35 GMT

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

Re: Convert into value

jagan — Wed, 27 Jun 2012 09:57:41 GMT

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.