Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.