Calculation

Hi!

I am building a slide in CP8 where you can enter an amount, interest rate, and length and it will give you the amount of interest charged.

I noticed that if a user inputs a comma in the amount (e.g. 5,000), that it won't work. However, it does work if you enter a period (e.g. 5000.55). I also think adding the percent sign (%) in that field isn't working either and a user must enter a number without that symbol.

Has anyone created something similar? What will work or not work for entering data in a TEB for the calculation? I also tried changing to Numbers only, but it won't allow you to enter a period.

Is there a way to include the comma and/or the percent symbol in the calculation?