XpressDox Help Center

Use Google To Find Help Fast, e.g. xpressdox choosefromlist

Press Getting Started in the XpressDox toolbar for basic template development
Watch the tutorial videos
View command help from list of commands
Press F1 for help on a command in the Command Editor
Email support@xpressdox.com for assistance

The RenderAsNumeric function

The RenderAsNumeric function

The calculation features of XpressDox require that values conform to a specific format. This format permits numeric digits, an optional leading sign (+ or -) and an optional decimal point. Thousands separators, spaces and other such characters are not permitted.

The RenderAsNumeric function will ensure that a data element value is converted to a format which can be used in the XpressDox calculations as well as in the FormatNumber function.

Examples of usage are:

«FormatNumber(RenderAsNumeric(Amount) * 1.1))»

The results of this (which is a formula to increase the value of Amount by 10%) for different values of the data element Amount are:

Data Element Amount Value of fillpoint
<Empty string> 0.00
100 110.00
1,000.00 1,100.00
2.000,00 2,200.00
+One Hundred 0.00

Leave a Reply