Drill down in Webi Column chart

[Former Member]

I have created a column chart in webi which shows a percentage on the y axis and mod centers on the x axis. I have two different percentages side by side. I create a navigation path on the business layer to drill down into part numbers. The percentage is based on the number of part numbers in a mod center. However when I try to navigate back to mod centers it changes my percentage to crazy numbers, like 65,000%. Please note that in my example the percentages cannot be higher than 100. I hope the information I provided wasn't too vague, but have any idea why this is happening?

P.S. I am using 4.1

Thanks in advance.

[Former Member]

Answering my own question, for anyone else who has this issue. I guess its a bad idea to calculate a percentage from the universe or any kind of division UNLESS we use the delegated measure that I guess was introduced into BO 4.0 (I think). If not then the percentage / division should be created on the report (Webi).

[Former Member]

Seems like my data provider is just corrupt. Anyone knows what could be causing this to happen? Just doing any kind of manipulation seem to be corrupting my values. Thanks in advance

[Former Member]

I have more details to add. This behavior occurred when I added other objects to my report. Once I refreshed my report the data went crazy and my percentages all changed to crazy values.