TextToNumber Function

Overview

The TextToNumber function is used to convert string values containing decimal dots (e.g., property values selected in dropdowns) into numeric values. This conversion is essential for incorporating these values into mathematical expressions or calculations within the Investment Model.

Application in Investment Model Expressions

In the Investment Model, calculations often depend on selections made within the Capex Request Form. These selections, typically stored as strings (such as dropdown options), need to be converted into numeric values for accurate processing in financial calculations.

Example Usage

TextToNumber(GetProperty("code_of_another_property"))/100

In this example, the TextToNumber function converts the value retrieved by GetProperty (in string format) into a numeric value. The converted value is then divided by 100, demonstrating how TextToNumber can be used to prepare property values for further arithmetic operations.