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]

I think I would use:

round(Count({< [Escalated Case Count] = {1}>} DISTINCT CustomID) / SUM ([Open Count]))

- Marcus

[Anonymous]

I did that, but all the numbers became 0

[sunny_talwar]

Round to how many decimals? It seems you have a division, is numerator smaller or bigger then the denominator?

[Anonymous]

you're right. I have small numbers as 0.24, 0.02 and so. This won't work

[sunny_talwar · Accepted solution]

May be Round to a decimal number

Round(Expression, 0.001)

[Anonymous]

Thank you, that worked!!!

[christian77]

I don't think it Works.

tABLA:
LOAD
trim(round(A,0.01))
FROM

(ooxml, embedded labels, table is Hoja1);

And the view is

1,2600000000000

3,6500000000000

7,3300000000000

800,0000000000000

1.533,1500000000001

when the original numbers are. One of these days will be fixed

1,264560000000000000000

3,654654654654650000000

7,330000000000000000000

800,000000000000000000000

1533,153300000000000000000

[marcus_sommer]

What is the problem?

[Anonymous]

There is not any problem, this was resolved a few months ago.