Creating a Prompt in a Query in a Computed Column

[winterfell]

I have large datasets that I need to calculate fees on. The fee is constantly changing. Currently I have a query with a computed column that I edit with the new percentage in order to get the fee amount. Is there a way to create a prompt so I can just enter in the new percentage amount, and the computed column formula will change without going into the query?

For a simple example, all of the rows in my data will have a 1% fee today. Tomorrow my new data will have a 2% fee.

Or is there at least a way to get a prompt to come up that says "remember to change the % amount"?

Thanks!

[Patrick · Accepted solution]

1. Define a prompt. Let's call it Fee

2. Use the prompt in the formula of your calculated column, i.e. amount * &Fee

[winterfell]

This worked perfectly, thank you so much for your help!