5 Replies Latest reply on Jan 10, 2014 9:37 AM by Aaron Clancy

    Can a Parameter have a default value based on a Calculation?

    David Biehl

      I would like to use parameters more to make some of the worksheets and dashboards more interactive. It seems like parameters have a "current value" which also appears to be the default value. I was wondering if the default value could be based on a calculation when the workbook is opened either in the desktop or on the server.

       

      A practical example would be to default the parameter to TODAY() so whenever the workbook is opened the default value is always the most recent date.