% GT of a column of type percent gives unusual sum value when charted with a clustered bar graph

[jefflanye]

Hi all,

I have a table with data that looks like so;

| Item Name | Availability  | Grouping|
| item 1         | 0.9%            |Group1 |
| item 2         | 0.2 %           |Group2 |
| item 3         | 0.5%            |Group1 |
| item 1         | 1.0%            |Group2 |
| item 5         | 0.01%          |Group1 |
| item 2         | 0.02%          |Group2 |

I am charting this on a clustered bar graph categorised by item name and the value Availability, issue is the availability  sum shows abnormal figures like 25000% for each category. Please kindly help how this should give figures between 0-100%

[amitchandak]

@jefflanye , if Availability values are like 0.09 then use % property. if this is already 9, then do not use percent display

[jefflanye]

Hello,

Values are like 0.01, 0.9 etc, could you please explain more, I have not got you well.