How to Add Currency in the Calculation?

I have a table with multiple columns, and the last column is where the applicant enters the amount they’re spending. This amount is set to auto-calculate into the "PROJECT / EXPENSE TOTAL" field. However, the total isn't displaying in currency format, even though the validation is already set to currency. How can I fix this?

Hi HCHDonations,

Thanks for reaching out to Jotform Support. The $ sign you added in the field is only a placeholder, which means it does not actually represent the currency value in calculations or conditions. To fix this, you need to add the currency symbol in your condition. When doing so, make sure the currency symbol is gray-coded to be recognized as a string rather than a number.

You can do this by clicking on the currency symbol in the condition editor and switching its type from number to string. This ensures the system treats the currency symbol correctly in your conditional logic. Here's a screencast of how it should look like:

Result:

Give it a try and let us know how it goes.

@sheena Thank you! However it does not format the number as currency like this: $2,232. It shows like this $2232. How can I add a comma to format as an actual currency?

Hi HCHDonations,

To format your calculated amount with commas as thousand separators, you can use the commaSeparate() function inside your condition's calculation. Here’s how to do it:

1. Open the condition where you perform the calculation.
2. Click the f(x) button to open the function options.
   
3. Select the commaSeparate() function and apply it to your calculated number field.
4. Ensure the currency symbol is added as a string (gray-coded) in the condition so it displays correctly alongside the formatted number.
   
   

This will format the number with commas, for example, $2,232 instead of $2232.

Result:

Give it a try and let us know if you need any other help.

Sheena, you are the best!