I have a table with 3 columns. The first column has a fixed number, 2nd is quantity, 3rd is total.

[murrjames]

I have a table with 3 columns. The first column has a fixed number (there is no field there, only col 2 and 3 have fields), 2nd field is Quantity1, 3rd is Total Fees.

In simplified field notation of the Total Fees field I put the dollar value from column 1 * the Quantity1 field.

so, 15,980 * Quantity1

the the fixed number is 15,980, the Quantity field I typed in 10. The total gave me 15, not 159,800.

[try67 · Accepted solution]

If the value is "15980" then drop the comma. If it's "15.980" then replace it with a period.

JS uses the common English notation for numbers, with no thousands separator and a period as the decimal separator.

[murrjames]

Many thanks