Your approach is the right one. Take the variable, ask user to enter value and use the variable in your chart calculation to change the values once variable has value.
And you dont need to do anything extra to discard the values. What so ever you do on browser doesnt effect the original file on server.
Dear Kaushik Solanki,
Thanks for your reply.
I was wondering in regards to the exchange rates which is inputted by the end-user, wouldn't it be stored and saved in our server?
Also, the amount of data being manipulated is very large. Wouldn't this use a lot of our servers' computing resources?
Will it be possible or appropriate to use the INPUTFIELD function to get this job done?
As the client has requested to be able to input exchange rate values to a few currencies.
The sales data that will be provided to them are in their own countries' currency.
Also, how will I be able to use this INPUTFIELD function?