syntaxcountcognosboolean-expressioncognos-11

How to count the lines with the specific value at Cognos 11?

lets say i have a column with many lines but only two values, A and B:

i am trying unsuccessfully to count only lines with A - in a summary calculation for a dashboard (without making a new column for this specific calculation) the expression which gives me syntax error is this:

count([column] = 'A')

any suggestion?

Solution

  • You'll need to use an if then else construct:

    count( if([Column]='A') then ([Column]) else (Null))