Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
I think I would use:
round(Count({< [Escalated Case Count] = {1}>} DISTINCT CustomID) / SUM ([Open Count]))
- Marcus
I did that, but all the numbers became 0
Round to how many decimals? It seems you have a division, is numerator smaller or bigger then the denominator?
you're right. I have small numbers as 0.24, 0.02 and so. This won't work
May be Round to a decimal number
Round(Expression, 0.001)
Thank you, that worked!!!
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 |
What is the problem?
There is not any problem, this was resolved a few months ago.