Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was looking for an expression that would give me number and percentage in a pie chart and found this:
=dual( Num(Count(Distinct key),'#.##0') & ' (' & num((Count(Distinct key))/(Count(Total Distinct key)),'#.##0%') & ')',
Count(Distinct key) +(Count(Distinct key))/(Count(Total Distinct key))*100 )
It shows number and % correctly, but the count is wrong.
If I use the previous expression:
=Count(Distinct key)
I get a smaller value.
So, what's I'm doing wrong?
Regards,
Pedro.
Edit: the smaller value is the correct one.
Mensagem editada por: Pedro Souza
Good to know. Thanks!
That's correct! That's exactly what I wanted.
Thank you very much.