Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

calculated columns not being populated when report is run as excel

  • 1.  calculated columns not being populated when report is run as excel

    Posted Wed November 29, 2023 04:29 AM

    Good morning from Germany,

    I have the following problem: I have a fairly simple report with lists. In the columns are simple calculations for the percentage deviation of months, such as (a-b)/b. 

    If I run the report as HTML, the calculations are executed. If I run the report as XLSX, the calculated columns remain empty. I have already experimented with the aggregation properties, but cannot find a solution. 

    Does anyone else have an idea why the calculated columns are not populated?

    Best regards
    Roger



    ------------------------------
    Roger Lewin All for One SE
    ------------------------------


Related Content