0 Replies Latest reply: May 15, 2018 11:30 AM by Michele De Nardi RSS

    Fiscal Master Calendar Flags

    Michele De Nardi

      Hi guys,

      my fiscal period starts on July, so July is my first fiscal month, and i want to create a simple fiscal master calendar with some flags like below:

       

      Fiscal Period: Calendar Period + 6 Months

      FL_CY: Current Fiscal Year

      FL_LY: Last Fiscal Year

      FL_LY-1: Last Fiscal Year -1

      FL_CYTM: Current Fiscal Year to Month

      FL_LYTM: Last Fiscal Year to Month

      FL_LYTM-1: Last Fiscal Year -1 to Month


      This is the expected result:

      How can i achieve this by using an elegant way ?

      2018-05-15 17_22_38-Cartel1 - Excel.png