Adding Parameters to Formulas 1

[SJW78]

CRXI

I've created a report that contains a formula to calculate the market value of an account (accunits*rate), what I'm trying to do is add a parameter so that when the user opens the report they are prompted to enter the effective date of the market value they are looking for.
I have two questions:
1) How do I set up the parameter? (ie. Should this be a static or dynamic value?)
AND
2) How do I associate the parameter to the formula?

Any help would be greatly appreciated!
Thanks,

 

[JDNordberg]

The parameter should be a static date parameter. How does the date effect your calculation?

 

[SJW78]

Thanks for the response! I have the parameter created & added to the report but my problem now is that I'm trying to use the Date Parameter to update my market value field.
Do you know how I get the date parameter to be linked to my market value formula?
Thanks!

 

[lbass]

Build the parameter into your formula, like:

if {table.date} >= {?date} then //etc.

-LB

 

[SJW78]

That did the trick! Thank you VERY much!