RenderAsNumeric - XpressDox

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: