Display minus before dollar symbol

  • Resolved jjcarlson

    (@jjcarlson)


    4 years ago

    If I’m using a calculated field, and the amount is negative, displaying in the expect form would be like the following:

    -$300

    Is there a simple way to achieve this? Thank you!

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    4 years ago

    Hello @jjcarlson

    No, I’m sorry, the minus is part of the number and not the currency. So, it will be displayed as: $-300

    There are two possible alternatives:

    1. Display the currency symbol at the end of the result (-300$).

    Enter the currency symbol into the “Symbol to display at the end of calculated field” attribute, in the settings of the calculated field.

    2. If the result is the last one and you are not using the field in another equation, you can force the format. Leave both attributes empties: “Symbol to display at beginning of calculated field” and “Symbol to display at the end of the calculated field”

    Now, if the equation is for example: fieldname1+fieldname2 edit it as follows:

    
(fieldname1+fieldname2).toLocaleString('en-US', { style: 'currency', currency: 'USD' });

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Display minus before dollar symbol’ is closed to new replies.