Formula (Parameter Update Method)

Choose this Update Method if you want to feed the parameter with a formula. Using that method allows feeding a parameter with a dynamic value that can also be calculated using another parameter content.

Example 1: a parameter must always give the value of the last year:

 

image\parameterformula1.gif

 

Example 2: a parameter can be updated using the value of another parameter.

 

image\parameterformula2.gif

 

In the above picture, the first parameter "number_of_last_days" will ask to enter a value (how many last days do you want to include in the criteria on the date field?)

Then the second parameter, "date_delay_param" will calculate the appropriate date using the value of the first parameter:

image\parameterformula3.gif

 

In the criteria dialog box, the second parameter is used to feed the criteria value for the date field:

 

image\parameterformula4.gif