2 Replies Latest reply: Feb 15, 2018 10:48 AM by Sunny Talwar RSS

    Set Analysis Help

    Erica Trotter

      Here is my formula:

       


        Sum({<[Activity Freeze Month Year Index] =Max({<[Month Year]=,Year = {'$(=Max({<[Month Year]=>}

        [Activity Freeze Year])-2)'}>}[Activity Freeze Month Year Index])>}[PL Counter])


      If I just put :

      =Max({<[Month Year]=,Year = {'$(=Max({<[Month Year]=>}   [Activity Freeze Year])-2)'}>}[Activity Freeze Month Year Index])


      in a text box it works and returns a 12, but it's not working inside the formula. Please let me know if you have any ideas!


      Thanks,

      Erica