4 Replies Latest reply: Aug 25, 2017 4:07 AM by Anindya Manna RSS

    Convert this expression into set expression

    Anindya Manna

      Below expression is for calculating previous month.

      =date(AddMonths(date#(max([FSPM Month Number]),'YYYYMM'),-1),'YYYYMM')


      I want to calculate previous month based on date filter. It should not affected by any other selection like product name and rep id.

      By using above normal exp. previous month calculation is changing as per selection like product name and rep id


      I want to date selection will change the calculation but not rep id or product name field.

      if I choose  05/05/2017 then prev moth should be 201704.Date filter should work but not other filter effect the result.