Round function not producing expected output

[amitdhote]

Hi Team,

We are using Round fucntion to round off RequestDuration column in our data pipeline.

But round function for RequestDuration column in GBQ is not rounding off if the last digit is 5 and not checking whether the previous value is even or odd, on other hand Splunk round function is adding 1 to the previous value irrespective of whether the previous value is even or odd if the last digit is 5.

Eg.

select ROUND(3775/1000,2) AS requestDuration

For above query expected output is "3.78" as per GCP Bigquery documentation(Eg. from documentation ROUND(1.235, 2)  output - 1.24 )

but instead we are getting value as 3.77 in GBQ, whereas in Splunk(Our old system), it is showing as 3.78 

Thanks in advance.

Regards,

Amit Dhote

[OlegS]

Hi @amitdhote 

I confirm the same thing on my side. You might want to report that bug to Google Support. As a workaround:
select ROUND(377.5)/100
works as expected.