rporter45
asked on
Adding a Parameter to a Formula
Good morning!
In a nutshell, I need to create a formula where the user identifies the date range and if there is a donation within that date range, then return the value of the donation.
I have created a parameter, ?Asks as of - this identifies a date range for the user to enter.
How do I combine the two in a formula?
If ?Asks as of then donation amount ? - I am missing something in the syntax here but can't think of it!
Thank you very much in advance,
cs
In a nutshell, I need to create a formula where the user identifies the date range and if there is a donation within that date range, then return the value of the donation.
I have created a parameter, ?Asks as of - this identifies a date range for the user to enter.
How do I combine the two in a formula?
If ?Asks as of then donation amount ? - I am missing something in the syntax here but can't think of it!
Thank you very much in advance,
cs
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much! It works now!
If {table.donation_date} in {?Asks as of} Then {table.donation_amount}