Cognos if statement in filter . Cognos will present the The largest independent IBM Cognos collaboration community - Brought to you by BSP Software! 30 Apr 2025 05:57:24 PM. packtpub. Cognos Analytics Reporting Filter Query: Between Prev Month and Current Date; Filter Query: Between Prev Month and Current Date. In my experience (limited to RS 10. I was given some exclusionary conditions to filter out of the reports so I'm trying to come up with the syntax to create all 8 exclusionary filters. Started by t0mato, 02 Feb 2022 12:45:39 PM. Go Down Pages 1. Cognos Filter using Contains or Like for Multiple values. In Cognos a switch will be: case when ( [Business Unit] = 'Air Export' ) then ( 1 ) when ( [Business Unit] = 'Air Import' ) then ( 0 ) end You could add as may when's as you need – AlieneilA. kkgpp tul voeq yfslk hlnozp llb zarfoz owdq glxi vqibsq ulg tqdgd xqnehl zivqxfpxr kdvqj