2 Replies Latest reply on Dec 7, 2013 8:01 PM by Ken Patton

    Dynamic Dating Parameter w/ Fiscal Calendar

    Jason Quint

      I've created a number of YTD and MTD metrics using a Current Period perameter b/c we use a fiscal period and i want my reports to be as of the most recent closed fiscal period.

       

      My problem is i have to go in and change that parameter every month on every workbook.

       

      I'd like to be able to set my parameter on some sort of a function that references today, and then what fiscal period does today fall into and then what is the period before this one.

       

      I've tried something like

       

      IF [FISCAL DAY] = TODAY()

      THEN [FISCAL MONTH]

      END

       

      Then set that calculation as a custom date field, then reference that customer date as the source of the parameter, but it shows up as 12/30/1899.....

       

      Any and all help is appreciated.