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.