1. Modeling
  2. Dimensions
  3. Lists
  4. Add formulas to list properties

Model builders add formulas to list properties to pull data from modules or line items into lists.

Create any lists or list properties you might need in General Lists in the model settings bar.

For example, if you want to create display names for a numbered list, set up a formula that pulls employee names into the Display name list property.

List propertyFormatFormula
Display nameText'SYS08 Employee Details'.Name

Another example shows how you can use a list property formula to preserve list item names before you convert a list to a numbered list.

List propertyFormatFormula
Display nameTextNAME(ITEM(Listname))

To add a formula to a list property:

  1. Select General Lists in the model settings bar.
  2. Select a list, then select Open.
  3. Select Properties.
  4. Type the formula in the list property's Formula column.