COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sunny1234 on 13 Dec 2007 10:39:52 PM

Poll
Question: Percentage calculation
Option 1: Report studio votes: 0
Option 2: percentage calculation votes: 0
Title: Report Studio
Post by: sunny1234 on 13 Dec 2007 10:39:52 PM
If (percentage(count(code)) = 100%)
then ('yes')
else ('no')

If i give the above statement the calculation and evaluation of that value is not working.
Please recommend how to achieve this.

Title: Re: Report Studio
Post by: kristysmith on 14 Dec 2007 10:47:08 AM
If (percentage(count(code)) = 100%)
then ('yes')
else ('no')


take out the % sign. (I am assuming that the 100% is a numeric field)