FMS Required !
I have created 2 UDF's say Bales(Numeric) and Tare Weight(Numeric). So my requirement is when I enter quantity in Bales UDF, Tare weight should calculate automatically through FMS.
I have created FMS as SELECT $[POR1.U_Bales]*0.5 and assigned to Tare Weight UDF but when I click on mirror icon to fetch data its giving me an error as 1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting nvarchar to data type numeric. '' (SWEI)
Please anyone guide me on how to solve this.
Check below FMS.
Hope this helps