Manual input with resulting table

Hello all,

I am trying to create a report that lists the following in a table (visual), for example:

- Part

- List Price

- Discount Price

I would like for "Discount Price" column to be a calculated column based on manual input; that is, I would like for the end user to be able to manually input a discount (for example, "20%") and see the results in the table (List price = regular price, Discount price = 20% of regular price).

Is this possible to do (manual input with resulting table)?