Author Topic: Cognos 8 - report to show when there is no value  (Read 12631 times)

Offline kac_zrg

  • Full Member
  • ***
  • Join Date: Oct 2018
  • Posts: 9
  • Forum Citizenship: +0/-0
Cognos 8 - report to show when there is no value
« on: 07 Aug 2019 08:47:12 am »
I have a data item in my report that counts the # of times target status was edited to the type "shortlist".  What I want to see is the line items the count is 0, not the ones that have hit this edit.

When I run the report, it will not show 0 count lines, is there a way I can flip this? I tried the expression that of:

case when ([Target Status] < '1'))
and
([PRESENTATION VIEW - JOB ANALYSIS].[JOB].[status] = 'signed agreement')
then ([PRESENTATION VIEW - JOB ANALYSIS].[JOB].[jobPostingID]) else '0' end

However, this does not work as the count only shows values 1 and higher, not 0.


Offline Francis aka khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 500
  • Forum Citizenship: +25/-4
    • CognosM
Re: Cognos 8 - report to show when there is no value
« Reply #1 on: 24 Oct 2019 01:21:32 pm »
not really sure what you are trying to do but try...

case when ([Target Status] < 1))

 


       
Twittear