Skip to Content
avatar image
Former Member

FMS for Subtracting 2 UDF !!!

Hi Every One,

I have 3 UDF's with datatype Alphanumeric as U_GrossWt, U_TareWt and U_NetWt. I want to do as follow U_GrossWt - U_TareWt = U_NetWt through FMS. I have tried using this FMS but not succeeded.

SELECT Cast($[POR1.U_GrossWt.numeric as float]) - Cast($[POR1.U_TareWt.numeric as float])

When I run abouve FMS I get error message as shown below

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'Cast', expected 'AS'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement '' (SEVT) (s) could not be prepared.

Can anyone guide me on subtracting 2 UDF's of Alphanumeric Type through FMS.

Thanks,

Harshal Makwana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 27, 2015 at 10:41 AM

    Hi,

    (SELECT $[POR1.U_GrossWt.decimal] - $[POR1.U_TareWt.decimal] )

    Thanks & Regards ,

    Kamlesh Naware

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kamlesh,

      I have tried and it works fine only changes I have did is replacing Decimal to Number as I was getting error on running FMS.

      Thanks for your help.

      Regards,

      Harshal Makwana