Number, Money, Percent

From RPM Wiki

Table of contents

1 Summary

2 Input

2.1 Places used
2.2 Positive & negative
2.3 Decimal places
2.4 Money validation

3 Display formatting

3.1 Money
3.2 Percent
3.3 Integer

4 See also

[edit]

Summary

There are various places in RPM where numbers are entered & displayed. This page covers the formatting rules for input and display of all three numerical data types:

Money
Percent
Number (integer)

Data

Data overview

Import Download

Data types View columns

[edit]

Input

[edit]

Places used

Money custom fields (manual & import)
Money data fields (manual & import)
Commission rates
Deposits
Commission items (manual & import)
Agency quotas
Reconciliation settings

[edit]

Positive & negative

Money and percent amounts are saved as a signed real number. Integers are saved as signed integers. In other words, any of the three may be negative.

[edit]

Decimal places

Money values will be rounded for display, but are always saved and calculated with up to four decimal places.

Validation: Limited to 4 decimal places maximum
Manipulation: Integers are rounded to the nearest whole number when saved.

[edit]

Money validation

Examples of valid money values

$0
0
(0.0000)
.01
$.0001
($.1),
0.1
1.
1.00
1,000.00,
$1.00
$ 1.0000
-1.00
-$1,000.00,
-$ 1
$-1.00
$(1,000.00)
$ (1.00)
($1.00)
123,456,789,012.3456

This is the regular expression we use

/^\-?\(?\$?\s*\-?\s*\(?(((\d{1,3}((\,\d{3})*|\d*))?(\.\d{1,4})?)|((\d{1,3}((\,\d{3})*|\d*))(\.\d{0,4})?))\)?$/

[edit]

Display formatting

Number, money, and percent values are always formatted for display.

[edit]

Money

Preceded by a dollar sign.
Separate thousands with a comma. Example: $1,250.25
Shown to 2 or 4 decimal places depending on field option. Example: $50.00
If negative show red & in brackets. Example: ($50.00)

[edit]

Percent

Followed by a percent sign.
Trim trailing zeros. Example: 50%
But show any decimals up to 2 if they exist. Example: 33.33%
Separate thousands with a comma. Example: 1,250.25%
If negative show red & precede with a dash. Example: -50%

[edit]

Integer

Shouldn't be any decimal places. Example: 50
Separate thousands with a comma. Example: 1,250
If negative show red & precede with a dash. Example: -50

[edit]