Cognos 11 Crosstab calculations

[zgeorge]

Hello Cognos Experts!

I have created a crosstab in report studio and am getting some unexpected results. I have created a case statement to say:

case
when caption([Year]) in ('2018') then 2
else 1
end

In a crosstab, the cells are blank when I run the report but when I run it in a list, it works just fine. I've attached screenshots to help explain the issue and show the results I'm getting.

[Lynn]

Hello Cognos Experts!

I have created a crosstab in report studio and am getting some unexpected results. I have created a case statement to say:

case
when caption([Year]) in ('2018') then 2
else 1
end

What is the aggregate property for your calculation? It needs to be seen as a measure to render in the cross tab intersection.

In a crosstab, the cells are blank when I run the report but when I run it in a list, it works just fine. I've attached screenshots to help explain the issue and show the results I'm getting.