Insert Member Property

XL3PropertyLookup formulae can be inserted directly into the spreadsheet using the FluenceXL > Insert Formula > Member Property ribbon or menu option.

To insert a member property:

1. Select the FluenceXL > Insert Formula > Member Property ribbon or menu option
2. Choose a location for the new formulae
3. Choose the connection to use from the dropdown
4. Select the hierarchy the desired property belong to
5. Select the member to use
6. Choose a member property from the Property dropdown
7. Click OK and the formula will be inserted

See Also

• XL3PropertyLookup formula reference