How can I categorize numeric fields?

  • Profile Image
    Asked on August 18, 2016 at 09:54 PM

    Hello -

    How can I specify that a number field is a percentage or currency with the appropriate symbol, such as the percent sign, dollar sign, pound sterling sign, etc?

    Thank you,


  • Profile Image
    Answered on August 19, 2016 at 01:26 AM

    Are you trying to perform a calculation on the numeric field and append a currency symbol?

    If yes, you can do that in the form calculation wizard. Here's a guide:

    By the way, since symbols are not allowed on the numeric field, I suggest using a regular textbox field instead.

    If I have misunderstood your question, kindly provide more details on what you're trying to achieve. Thanks!

  • Profile Image
    Answered on August 19, 2016 at 02:45 AM
    Hello Elton - I have used the "Calculation" widget to perform the
    mathematical functions, so I'm good with that. I would like to show on
    the form that the number refers to dollars or percent. How can I do that?
    For example, I have a numeric field for annual income in which I
    multiply the monthly income * 12. How do I show that number is
    referring to currency?
    Another example is percent. I have a field to indicate the COLA (cost
    of living adjustment) percentage. I have used whole numbers for these
    fields, but there is nothing to indicate that it's a percentage. For
    example, to indicate a 2% COLA, I have entered 2. Should I enter .02?
    How will it be identified as a percentage?
    Thank you for your help!
  • Profile Image
    Answered on August 19, 2016 at 05:17 AM

    You can add dollar sign or percentage sign inside of your calculation filed before or after calculation.

    Hope this will help. Let us know if you need further assistance.