How to add dollar sign to calculation widget field?

  • ronjaffe
    Asked on May 11, 2016 at 4:15 PM

    Looking to provide residents with a simple way to estimate what a proposed tax increase would be. This page functions well, but would be better if the numbers showed as dollars  (with $ and commas).

    Can this be achieved?

    Thanks.

    Ron Jaffe

    jaffeent@earthlink.net

  • Nik_C
    Replied on May 11, 2016 at 5:11 PM

    Please try following:

    1. Open wizard of your calculation widget:

    How to add dollar sign to calculation widget field? Image 1 Screenshot 40

    2. And just put the dollar sign before the actual calculation:

    How to add dollar sign to calculation widget field? Image 2 Screenshot 51

    3. You will get something like this:

    How to add dollar sign to calculation widget field? Image 3 Screenshot 62

    Can you please try and let us know if this solution is good enough.

    We'll wait for your response.

  • ronjaffe
    Replied on May 11, 2016 at 5:44 PM
    Excellent. Thank you for the incredibly rapid response Very much
    appreciated. Dollar signs now appear.
    Any way to have commas display?
    Thanks again.
    Ron Jaffe
    ...
  • Nik_C
    Replied on May 11, 2016 at 6:14 PM

    You're welcome!

    Please try to add decimal places through calculation widget wizard:

    How to add dollar sign to calculation widget field? Image 1 Screenshot 40

    Click Show Advanced Options and turn on this options:

    How to add dollar sign to calculation widget field? Image 2 Screenshot 51

    It will show the number in this format:

    How to add dollar sign to calculation widget field? Image 3 Screenshot 62

    Let me know how that worked for you!

     

  • ronjaffe
    Replied on May 12, 2016 at 7:44 AM
    What Im looking for is for commas to appear so $250,000 would include the
    comma instead of being displayed as $250000.
    Is this doable?
    Thanks.
    Ron Jaffe
    ...
  • Nik_C
    Replied on May 12, 2016 at 9:43 AM

    I'm assuming that you are referring to 'Value of your house' field?

    Since that field is Calculation field and your users are inputting their values there, maybe you could use Masked input widget as that field(since there is no actual calculation there) and format as you wish.

    Then you can use that field in your actual calculations:

    How to add dollar sign to calculation widget field? Image 1 Screenshot 20

    Please let us know if that could work for you.

    Thank you.

     

  • DioPT
    Replied on November 30, 2016 at 2:55 PM

    Same problem - click the ellipses in number pad for the Options!

    How to add dollar sign to calculation widget field? Image 1 Screenshot 20