Difference between revisions of "Insert Member Property"
(Created page with '{{Code|XL3PropertyLookup}} formulae can be inserted directly into the spreadsheet using the {{Menu|XLCubed|Insert Formula|Member Property}} ribbon or menu o…') |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| Line 1: | Line 1: | ||
| − | {{Code|[[XL3PropertyLookup|XL3PropertyLookup]]}} formulae can be inserted directly into the spreadsheet using the {{Menu| | + | {{Code|[[XL3PropertyLookup|XL3PropertyLookup]]}} formulae can be inserted directly into the spreadsheet using the {{Menu|FluenceXL|Insert Formula|Member Property}} ribbon or menu option. |
''To insert a member property:'' | ''To insert a member property:'' | ||
| − | # Select the {{Menu| | + | # Select the {{Menu|FluenceXL|Insert Formula|Member Property}} ribbon or menu option |
# Choose a location for the new formulae | # Choose a location for the new formulae | ||
# Choose the connection to use from the dropdown | # Choose the connection to use from the dropdown | ||
Latest revision as of 09:27, 4 July 2023
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:
- Select the FluenceXL > Insert Formula > Member Property ribbon or menu option
- Choose a location for the new formulae
- Choose the connection to use from the dropdown
- Select the hierarchy the desired property belong to
- Select the member to use
- Choose a member property from the Property dropdown
- Click OK and the formula will be inserted
