Prompt for a non-package item?

[jessimica602]

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!

[seb24c]

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.

[jessimica602]

This worked perfectly! Thank you!

[seb24c]

Great! Happy to help!