如何设法得到圆形值的总和为非圆形？ [英] How to manage to get sum of round values to be non round ?

问题描述

在一个网格上我显示的值总和是基于某些标准



ROUND（SUM（ISNULL（dry.OffHours，0））/ @ DailyWorkingHours，0）aS OffTerritoryDays

给我

0.06

0.06

0.06



现在，在其他要求中我想要将所有这三个值的总和显示在一起

所以我的预期结果应该是0.18但我得到0.19，因为它再次舍入值，这使得0.19



我尝试过：



我用于我的另一张桌子



ROUND（SUM（ISNULL（ dry.OffHours，0））/ @ DailyWorkingHours，0）aS OffTerritoryDays，



现在给我0.19的内容0.18



请建议

解决方案

尝试：

 SUM（ROUND（ISNULL（ dry.OffHours， 0 ））/  @ DailyWorkingHours ， 0 ） aS  OffTerritoryDays，

Hi ,

on one grid i am displaying sum of values which are based on some criteria

ROUND(SUM(ISNULL(dry.OffHours, 0)) / @DailyWorkingHours,0) aS OffTerritoryDays
which gives me
0.06
0.06
0.06

Now , in other requirement i want to disply sum of all this three values all together
so my expected outcome should be 0.18 but I am getting 0.19 as it is again rounding the values and which makes it 0.19

What I have tried:

I am using for my other table same

ROUND(SUM(ISNULL(dry.OffHours, 0)) / @DailyWorkingHours,0) aS OffTerritoryDays,

which is now giving me 0.19 insted of 0.18

Please suggest

解决方案

Try :

SUM(ROUND(ISNULL(dry.OffHours, 0)) / @DailyWorkingHours,0) aS OffTerritoryDays,

这篇关于如何设法得到圆形值的总和为非圆形？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！