How to use the Round () function?

[Anonymous]

Hi,

I am trying to use the round function on the following expression:

Count(DISTINCT If([Escalated Case Count] = 1, CustomID, Null())) / SUM ({$}[Open Count])

What I did, was to add the Round at the beginning of the expression, but looks like it's not working at all. It's not calculating it. I also have tried to use it before the CustomID, but the expression show me an error.

Can you please provide me any guidance on where can I use the Round function for this specific expression.

Thanks,

[marcus_sommer]

My answer was directed to the current question from christian77.

[christian77]

Hi Marcus.

1.533,1500000000001

Do you see the last decimal? ...001. That is the problema. It does NOT round.

I'm using version 12.10.20000.0 SR2

The first versión I used was 8.5

Thanks.

[marcus_sommer]

This behaviour is related to the used binary number-system which is very well explained here: Rounding Errors.

- Marcus

[christian77]

Hi Marcus.

Thanks, now I understand everything. That was it! Floating binary decimal numbers written in hexadecimal. Perfect! Awesome!

Now, do we have something for this world, here on earth?

We have thousands of those numbers.

Differences are wrong, because numbers are binary.

How I’m going to explain that to my client?

[marcus_sommer]

Explaining ... it's just a design-decision from the past because of performance reasons (for example quite similar to Excel). Handling ... will be difficult and depends on the specific use-case maybe with round off/up to fewer digits, maybe a hard-cutting and probably some more measures ... but if the application needs to handle quite large/small number with many digits and a high degree on accuracy you might need a different tool.

- Marcus