Percentage in Block Chart

[Anonymous]

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.

[Sokkorn]

Hi,

Let try this expression: NUM(COUNT(DISTINCT {<>} ID) / COUNT(DISTINCT {<>} TOTAL ID),'###.00%')

Regards,

Sokkorn Cheav

[CELAMBARASAN]

Hi,

     Try by check the Relative option in the expression tab.

check with the attached image.

[Anonymous]

Hello,

as ID do you mean Id_autorizacion?

and what should I insert between the {<>} marks?

[jagan]

Hi,

Try the following expression

=NUM(COUNT(DISTINCT ID) / COUNT(DISTINCT TOTAL ID),'###.00%')

Regards,

Jagan.

[Anonymous]

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.