How to format currency fields on the form

[Margo]

@ShantiBhattarai,

To get the integer from the currency column of the 'List or Library' control you need to leave only number signs with the code like this:
parseInt(data[i].Quantity1.replace(/[^0-9.]/g, ""));

Also please see how to calculate the total for a column of the 'List or Library' control in this post:

Getting Sums from related List view

Hello @Jamal_Smith-Graham ! To calculate the sum and show it in the form is the only option to display the total by the column. To do so, please use the code below. Also, you can disable the Total field so a user will not set it manually. Please do the following changes in the code: Replace {SPDataTable0} with the List or Library Control internal Name. [image] Change Value in the code (in places like value[i].Value and value[i].Value.replace(/$/g,'')) with the InternalName of the Total…