7 Replies Latest reply on Nov 13, 2018 5:49 PM by Dan Cory

    convert FYTD

    Mikey Michaels

      Hello,

      I hope this message finds you all well.

      I have been scouring the internet to help me with my problem - I think it is pretty elementary; however, I just started so I'm having a hard time following the online blogs, webpages, etc.

      Anyways, on the attached, I would like to calculate the fiscal year to date based on the selection from the parameter "Select Date". My companies fiscal year starts in October and obviously ends in Sept,

       

      the solution would show, if the "select date" parameter was set to "November 2018" then the viz would only show Oct 2018 and Nov 2018. Another example if the date was set to September 2018, you would see October 2017 to September 2018.

       

      Thank you all!

      Cheers!

      Andrew