1 Reply Latest reply on May 10, 2018 11:23 AM by Jim Dehner

    could please anyone help with this formula

    Silvia Assuncao

      Could please someone help me fix this formula:

      Max_Closing_Period_Year.PNG

        • 1. Re: could please anyone help with this formula
          Jim Dehner

          HI

           

          change the lod to this - in words it says for each year give me the max closing period

           

           

          and it will return for 17 and 18

           

           

          you can of course filter the fy

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.