Aggregate and Percentages

[kc9400]

Hi all,

I've got the issue where if one side has a value of 100% and the other side has no value then the total % is 100% in the results.

I'm not great at explaining exactly what's going on but if you take a look at the attached screen shot it will explain things a lot clearer.

The top 2 highlit show that the % appears to work out correctly when the Utilized is empty but when the non-utilized is empty and the utilized populated it just gives the result of 100%

how can I prevent this from happening?

[kc9400]

I worked out what was causing the results to display the way they were but I'm not sure as to why.

The Text for the data 1.Utilized and 2.Non-Utilized is created in cognos using a CASE as initially it would display a 1 or a 0. I found that removing this CASE the % was then calculated correctly.

And that's where it all went over my head and I didn't understand why that makes a difference. Anyway this is now resolved.