1 2 Previous Next 20 Replies Latest reply on Feb 16, 2018 2:34 PM by Greg Mooney

    Create a calculated field to determine number of weeks selected in filter?

    Greg Mooney

      I have a data set that let's users selected from any of the 52 weeks of data.

       

      I want to create a calculated field that will in essence allow me to show in the title of the worksheet that this data is "13 weeks ending xx-xx-xxxx" or whatever number of weeks the user has selected.

       

      I already have the xx-xx-xxxx part figured out via:

       

      "13 Weeks Ending " + STR([Max Week Ending])

       

      But I want to enable the 13 to be variable based on user selection.

       

      Any ideas?

        1 2 Previous Next