Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Calculation

Community Beginner ,
Sep 15, 2015 Sep 15, 2015

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?

122
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 15, 2015 Sep 15, 2015
LATEST

Indeed, Americans use a period instead of a comma and that is the reason for that limitation. If you really want to try with a % I would recommend using JS instead of advanced/shared actions.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Help resources