Hey all,
I am needing a prompt for a non-package item. So what I need to happen: when you run the report you get a prompt that asks head of household with a yes or no drop down list. The answer is what will hopefully trigger which calculation is going to be used in one of the fields.
I can't seem to figure out how to add a prompt that asks this, I have tried adding a field that had 'Yes'or'No', clearly didn't work but it was a shot in the dark.
Anyone know if this is a possibility?
Thank you!
Create a value prompt on your page with no filter or query. Set the static choices (in properties) to Yes and No.
Then add the prompt to your calculated field like:
if ( ?p_HeadOfHousehold? = 'Yes' ) then ( this calculation ) else ( this other calculation )
It will have to be a required prompt if you do it this way, otherwise you'd have to use a macro in your calculated field which is a little more complicated.
Edit: Forgot the ?s around the prompt.
This worked perfectly! Thank you!
Great! Happy to help!