Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
replied

Hi,

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

Thanks & Regards ,

Kamlesh Naware

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question