GetProperty Function
The GetProperty
function retrieves the value of another property using its property code. It is especially useful for:
Pulling property values into model expressions in the investment model
Combining or calculating values across multiple properties
Ensuring consistent data references across your configurations
Parameters
Property code
The property code is the unique identifier used to reference a property in expressions.
To find the code:
Go to the Property List.
Click the ✏️ Edit (pen) icon next to the property.
The Code field is displayed in the property settings.
📌 The code may include letters, numbers, and underscores. It’s best to keep it short, descriptive, and consistent.
Using GetProperty in property expressions
You can use the GetProperty
function inside property expressions to perform calculations using values from other properties.
Example
=GetProperty("risk_rating_1")+GetProperty("risk_rating_2")
This expression sums the values of two risk rating properties.
Using GetProperty in the investment model
In the investment model, GetProperty
can be used to dynamically pull numeric values into your calculations.
⚠️ Only use properties with numeric types: Money, Integer, or Decimal in investment model formulas
Example
=GetProperty("total_risk_rating")
This expression fetches the numeric value of the property with the code total_risk_rating
and uses it in the model.
Troubleshooting tips
Check the code: Ensure you're referencing the correct property code, not just the property name.
Verify property type: In investment model expressions, make sure the property you're referencing is of a numeric type — Money, Integer, or Decimal.
Using a non-numeric type (like text or boolean) will cause the expression to fail.Reset the cell: If the model cell appears red or shows an error, try resetting the cell to clear the issue.
Balance your parentheses: Double-check that every opening bracket has a matching closing one to avoid syntax errors.