The function MakeNumeric() accepts a numeric value with followed minus sign and returns it as a negative numeric value.
see also MakeNumericEx
MakeNumeric('Value')
MakeNumeric('Value', <Empty Value>)
| Code | Result |
|---|---|
MakeNumeric('')
| NULL |
MakeNumeric('', 0)
| 0 |
MakeNumeric(' ', 0)
| 0 |
MakeNumeric('aaa')
| NULL |
MakeNumeric('aaa', -1)
| NULL |
MakeNumeric(<Empty x-path result>) | NULL |
MakeNumeric(<Empty x-path result>, 0) | 0 |
MakeNumeric('6.25-' )
| -6.25 |
MakeNumeric('6,763.5')
| 6763.5 |
MakeNumeric('6.971,12')
| 6971.12 |