Scale edits are used with the calculation function =. The scale edit either truncates the decimal position or adds zeroes. No rounding occurs in scale edits.
The scale is between 0 - 4:
0 - no decimal
1 - 1 decimal position
2 - 2 decimal positions
3 - 3 decimal positions
4 - 4 decimal positions
The following are examples for each value and the result of the entry in the Length/Function field for the numeric export choice:
Sample Value: 45
=0 - scale of 0 = 45
=1 - scale of 1 = 45.0
=2 - scale of 2 = 45.00
=3 - scale of 3 = 45.000
=4 - scale of 4 = 45.0000
Sample Value: 45.12
=0 - scale of 0 = 45
=1 - scale of 1 = 45.1
=2 - scale of 2 = 45.12
=3 - scale of 3 = 45.120
=4 - scale of 4 = 45.1200
Sample Value: 45.1234
=0 - scale of 0 = 45
=1 - scale of 1 = 45.1
=2 - scale of 2 = 45.12
=3 - scale of 3 = 45.123
=4 - scale of 4 = 45.1234
Return to Data Export Numeric Calculations