Please enable JavaScript to view this site.
From version 6.2.57 - This program will allow you to compare two numeric values and return whether Parameter 1 is Greater Than, Equal To or Less Than Parameter 2. The values passed in may contain non numeric characters such as a currency symbol, thousand delimiter etc. and may also be negative (with the minus sign at the right of the number e.g. £1.00-). They may also contain different numbers of decimals.
Parameter |
In |
Len |
Out |
Len |
Comment |
PARM1 |
Value to compare against |
21 |
*GT *EQ *LT |
3 |
PARM1 > PARM2 PARM1 = PARM2 PARM1 < PARM2 |
PARM2 |
Value to compare with |
21 |
|
||
PARM3 |
Decimal point e.g. “.” or ”,” |
1 |
|
If left blank defaults to “.” This is required for Europe where decimal point is a comma. |
|
PARM4 |
|
|
|||
PARM5 |
|
|
|||
PARM6 |
|
|
Examples
PARM1 |
PARM2 |
PARM3 |
Returned |
£1,234.567 |
1234.567 |
|
*EQ |
1.24- |
1.24 |
|
*LT |
1.245 |
1.24 |
|
*GT |
€1.234,567 |
€1.234,568 |
, |
*LT |