1 Reply Latest reply on Jul 9, 2017 3:22 AM by MANI BOJJA

    YTD or month to date text boxes

    Alex Martino

      I have data from 2016 and 2017. Right now I have a text box that shows March 2017 (but I have it from filters).

       

      How can I create a formula that will show most recent month (complete) month in 2017 and then the same month for 2016.

       

      Then I want the same thing but for YTD. I would like the user to be able to choose Month or YTD (vs prior YTD)  and have that info show up.

       

      I also would like to do the same thing, but subtract 3 months from the final month. Thanks.