Calculat Percentage in a Chart Expression

[alec1982]

hi guys,

I have a field as follow:

Broker

ABC

XYZ

ARS

ARS

XYZ

ABC

ABC

I need to build a chart to show the percentage of that field to total nr.

Like Perecentage of ABC= 4*100/7= 57.14

If I add the field broker as dimenssion and then Expression as Count(Broker)*100/Count({1}Broker)  I get 100% each.

Any solution.

Thxs,

[MayilVahanan · Accepted solution]

Hi

Try like this

=Count(Broker)*100/Count({1} total Broker)

Hope that helps

[alec1982]

Thxs!

[alec1982]

Sorry to inturppt you again, but still have one more thing:

how can i format the number to show the % next to it.

Thxs

[v_iyyappan]

Hi,

referred the below image its help for u.

Iyyappan.

[MayilVahanan]

Hi

Use Something like this

Num((Count(Broker)*100/Count({1}total Broker))/100,'##0.0%')

Hope it helps