Rounding off to an integer using NUM

[chhavi376]

I was trying to round off all my numbers to integer but i came across this problem:

if i use '#,##0.00'  in num, i get these numbers:

When we round this off, it should ideally be 16, 27 and 35

But when i use '#,##0'  in num, i get these numbers:

[chhavi376]

these are the backend values:

This is the expression i am using:

round(Sum( {<flag={1},Products-= {'Product1'}, Metric_Type={'abc'} >}  Metric_Value_N),1)

This is the output in the table:

[saimahasan]

please find attached file after using round()

[vinieme12]

use CEIL() to roundup values

[#5]

remove ,1 and check like this

round(sum(value))

[adamdavi3s]

Hi chhavi376‌

Are you 100% sure on the degree of accuracy of your source data?

I have been foxed and infuriated before by this sort of thing, please see the attached file noting items A and H in the table and how the different rounding accuracies produce different answers

SSMS can also sometimes be a bit of a douche, i'd run something like CAST(yourfield AS float) just to be 100% sure.

If that shows 15.5 then I am stumped!

[chhavi376]

It is still giving the same values.

[chhavi376]

I just checked.

It is working fine in your QVW.

I really don't know why is it coming wrong in mine.

[chhavi376]

Hi Adam,

I queried it in my SQL server.

My data in the reporting table in only upto one decimal place.

[adamdavi3s]

I am totally baffled then I am afraid!

Its very weird indeed.

Have you tried to just create a straight forward app purely pulling that field and testing the rounding?

That would at least point us to either a data issue or an app issue!

[Anil_Babu_Samineni]

From your Report 13.5 -- What are you expecting. Because, These are giving exact Round Values without Decimals. Let me know your expectation from that Report value