MoneyThousandSep

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset which is loaded into a table named Transactions.

• Provided data that has its monetary field in text format with a comma used as the thousands separator. Each record is also prefixed by a ‘$’ symbol.

Keep in mind that the MoneyFormat system variable defines dollar ‘$’ as the default currency.

Load script

SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$###0.00;-$###0.00';

Transactions:
Load
date,
id,
amount
Inline 
[
date,id,amount
01/01/2022,1,'$10,000,000,441'
01/02/2022,2,'$21,237,492,432'
01/03/2022,3,'$249,475,336'
01/04/2022,4,'$24,313,369,837'
01/05/2022,5,'$7,873,578,754'
01/06/2022,6,'$24,313,884,663'
01/07/2022,7,'$545,883,436'
01/08/2022,8,'$35,545,828,255'
01/09/2022,9,'$37,565,817,436'
01/10/2022,10,'$3.454.343.566'
];

Results

Load the data and open a sheet. Create a new table and add this field as a dimension:amount.

Add the following measures:

• isNum(amount)

• sum(amount)

Review the results below. The table demonstrates the correct interpretation of all values using comma ‘,’ notation as the thousands separator.

The amount field has been interpreted correctly for all values, with the exception of one value which used a dot '.' as the thousands separator.

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset which is loaded into a table named Transactions.

• Provided data that has its monetary field in text format with a dot '.' used as the thousands separator. Each record is also prefixed by a ‘$’ symbol.

Keep in mind that the MoneyFormat system variable defines dollar ‘$’ as the default currency.

Load script

SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='$###0.00;-$###0.00';

Transactions:
Load
date,
id,
amount
Inline 
[
date,id,amount
01/01/2022,1,'$10.000.000.441'
01/02/2022,2,'$21.237.492.432'
01/03/2022,3,'$249.475.336'
01/04/2022,4,'$24.313.369.837'
01/05/2022,5,'$7.873.578.754'
01/06/2022,6,'$24.313.884.663'
01/07/2022,7,'$545.883.436'
01/08/2022,8,'$35.545.828.255'
01/09/2022,9,'$37.565.817.436'
01/10/2022,10,'$3,454,343,566'
];

Results

Load the data and open a sheet. Create a new table and add this field as a dimension:amount.

Add the following measures:

• isNum(amount)

• sum(amount)

Review the results below, demonstrating the correct interpretation of all values using dot ‘.’ notation as the thousand separator.

The amount field has been interpreted correctly for all values, with the exception of one value which used a comma ',' as the thousands separator.