Use of variable in table to calculate another number

[paul_ripley]

Hello

I have number of costs in different offices that I need to allocate to the different business units based on a percentage.  The percentage might each month.  The calculation is simple, total office cost multiplied by percentage.

I could hardcode this but I would like the user to be able to change the percentage on the screen and then the table update.

Can anyone suggest how you would do this?

Many thanks

Paul

[vishsaggi]

Use Inputbox object and create a variable. Then use that variable in your expression.