I have the following fields:
Field1:
0.00
Field2:
94777.58
Field3:
223000.00
FinalNumber = (Field1 + Field2)/Field3
Trying to get this Final Number value to 19 spots post the decimal in accuracy using SQL server. Tried using Cast((Num1 + Num2)/Num3)AS Decimal(31,19) but it’s not working correctly. Can someone please help?