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.
Quote from: zgeorge on 09 Jan 2019 06:56:12 AM
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.