Percentage shows different in datagrid then in Reports

[efeurich]

Hi There,

I am struggling with this issue.

I have a percentage column that is set up as a percentage column. In the data view section the data shows up as 80.00%  and 41.00%. So that seems fine. But when I look at the data in the report (visuals) I see 800.00% and 410.00%.

Can someone please point me in a direction for a solution?

Thanks in advanced.

[amitchandak]

@efeurich , Is you column have value(after removing % attribute from column tools) .08 for 80 % of 80 .

If it is .08 for 80%, then you should mark it as % column, else you should divide it by 10 and then mark it as % column

[efeurich · Accepted solution]

Hi amitchandak,

Your suggestion did not resolve the problem.

I resolved the problem by creating a new column and performed a measure from 2 other 2 other columns that calculated the percentage (that was already in the data) and that resolved the problem.

I also had to set the value (in the visual with the percentage) to average, and that did the job.

I guess I have to look at the source data to see what is the base of this.

Thanks for your time and effort.