Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Current Month Minus Current Day Filter

    Posted Sun August 11, 2024 04:22 PM

    Can someone show me what the function would look like to create a detail filter for the current month minus the current day? #Cognos Analytics with Watson



    ------------------------------
    Andy Rock
    ------------------------------


  • 2.  RE: Current Month Minus Current Day Filter

    Posted Tue August 13, 2024 10:25 AM

    This filter should do it. Set the  [as_of_date] to the required date ( e.g. current_date )

    [Date] between _first_of_month ( [as_of_date]) and (_add_days ([as_of_date],-1) )


    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------