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!
... View more