Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this block chart, and I have a section called OTHERS, well, in each section different from others I have my percentage. But the OTHERS section gives me a decimal number. How can I make that OTHERS section percentage?
I attach two images that could be helpful.
Hi,
Let try this expression: NUM(COUNT(DISTINCT {<>} ID) / COUNT(DISTINCT {<>} TOTAL ID),'###.00%')
Regards,
Sokkorn Cheav
Hi,
Try by check the Relative option in the expression tab.
check with the attached image.
Hello,
as ID do you mean Id_autorizacion?
and what should I insert between the {<>} marks?
Hi,
Try the following expression
=NUM(COUNT(DISTINCT ID) / COUNT(DISTINCT TOTAL ID),'###.00%')
Regards,
Jagan.
Hello, I've done that, but the group OTHERS keep showing as a decimal number, it doesn't matter if I check Relative Option.
The other values are showing as percentage. All I want to know is what percentage correspond to OTHERS group.
Look what I got OTHERS = Otros (the aggrupation that QV make with a bunch of data), that's the one I don't understand the problem with the percentage.