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:

  1. Go to the Property List.

  2. Click the ✏️ Edit (pen) icon next to the property.

  3. 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.

image-20250407-130740.png

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.

image-20250407-131738.png


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.

image-20250407-132444.png


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 typeMoney, 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.