Posted 8 September 2017, 1:26 pm EST
i have this formula in spread. "score divided by total item multiplied by 60 plus 40 multiplied by percentage.
example: ((71/95) * 60 + 40) * .15. What is displaying in the spread is 12.73 actually if I am going to use excel or calculator the result is 12.72632.
I save the result in a table (sql) but what is being saved in the table is only 12.72 the datatype i used in sql is numeric(5,2). How do I make the spread display 12.72 and not 12.73?