Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Report omitting rows if calculated fields are zero

    Posted Mon April 14, 2025 10:00 AM

    I have a report using a data module that includes two calculated fields.  When I include these fields on the report and both are zero, the entire row is omitted.    When I take them out the row is included again.   There is nothing in the query that is qualifying on these fields.  Has anyone experienced this?



    ------------------------------
    Jeremy Reed
    ------------------------------


  • 2.  RE: Report omitting rows if calculated fields are zero

    Posted Mon April 14, 2025 10:43 AM

    Zero Suppression might be enabled for list. In crosstab, generally zero and nulls are suppressed. Kindly check.

    1. From the File menu, click Preferences.
    2. On the Suppress tab, in the Suppression Options box, do the following:
      • To suppress a row or column containing all zero values, select Zero Values.
      • To suppress a row or column where all cells contain values as a result of dividing by zeros, select Division by Zero.
      • To suppress a row or column where all cells contain missing values, select Missing Values.
      • To suppress a row or column where all cells contain values larger than the measure's storage type allows, select Overflow Values.


    ------------------------------
    Jashan preet
    ------------------------------