Using Cell References

You can enter references to single cells for connection, label, data/text, or variable arguments.

To use cell references:

1. Follow the steps in Creating Functions in the Function Builder to open the Function Builder panel.
2. In the Function Builder panel, for each argument in the selected function, select the cell in the sheet to reference, and then click the Cell Reference button, .

   You can also hand type the cell reference using the following syntax:

   ""&<column letter><row number>&""

   For example:

   ""&A3&""

   Notes:

   • If the member name that you selected in this step is displayed as dimension#member in the grid, then the argument selection is complete. For example, if the member is displayed in the grid as Year#Qtr 2 in cell A3, then ""&A3&"" is complete.

     If only the member name is displayed in the grid, then you must manually enter the dimension name followed by # between the first two sets of double quotation marks. For example, if the member is displayed as Qtr2 in cell A3, then you must enter Year# between the quotation marks: "Year#"&A3&""

   • If an argument text field contains text before you select a reference cell, the cell reference text is appended to this text. Therefore, delete any unwanted text in the field before selecting a cell for reference.

   • If a date cell is directly referred as input, then convert the input to the proper text format using a Text function as follows; in this example, cell B3 contains a proper date:

     =HsSetValue(TEXT(B3,"dd/mm/yyyy"),"ConnectionName", "dim#member"…)

3. When you have finished entering cell references, click Apply.
4. Refresh the sheet.