INFOR.READ.VALUE
This function returns any property of the selected cell. By default, it returns the Value property.
Syntax
The function has this syntax:
INFOR.READ.VALUE("data_connection", "cube" {, "cell_property", "cell_coordinate", ... })This table shows the parameters and their descriptions:
| Parameters | Description |
|---|---|
data_connection |
Represents the database unique name. It is a string or a cell reference. |
cube |
Represents the cube unique name. It is a string or a cell reference. |
cell_property |
Represents the cell property unique name. The
default value is value. It is a string or a
cell-reference.To read cell notes, use the |
cell_coordinate
|
Represents the element unique name and must be provided in its long form. It is any number of strings or cell references, up to Excel's limit of 252. |
Return values
This function returns a single value. It supports implicit aggregation.
When you provide multiple cell_coordinate arguments from
the same hierarchy, it returns an aggregated value of all specified elements from the
specified hierarchy.
For example, if you specify Sales from North America for 2016, 2017, and 2018 years, it returns a sum of values for these years.