1 Reply Latest reply: Jun 27, 2012 5:57 AM by jagan mohan rao appala RSS

    Convert into value

    John Lauridsen

      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