1 Reply Latest reply: Jul 6, 2016 8:50 PM by Daniel Jenkins RSS

    NPrinting less than filter to select a range of months

    Martyn Lloyd

      It is now July - month 7 and I want to select Jan to June, using a filter


      =KPIMonth<7 works great, but I need this to be dynamic so I tried




      This creates an invalid result


      Can anyone help?


      kind regards