Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vignesht50
Yak Posting Veteran
82 Posts |
 Posted - 2014-03-19 : 07:32:03
|
| Hi, I have already summed the values and this below query sum the values and returns zero if there are no values. How can I roundoff the values for these columns.isnull(sum([Old_Values]),0) [Old Values],[New_Value] = isnull(sum([Yearly_Value]-[Previous_Year_Value]),0) Even this query I use for calculation and I need to round off the values [Product_Price] = [Product_Profit]/4, [Product_Profit] = [ActualValue] * 0.75,[GrossValue] |
|
|
maunishq
Yak Posting Veteran
71 Posts |
Posted - 2014-03-19 : 10:25:19
|
| e.g. [Product_Price] = ROUND([Product_Profit]/4,*) where * = number of decimals you want to round of to.=======================Not an Expert, Just a learner.!_(M)_! |
 |
|
|
|
|
|
Round off sum values