GetCellRealData
Gets the data contained in a cell and also indicates whether the cell contains real data. This function can be used in these types of rules:
-
Calculation
-
Translation
-
Consolidation
-
Allocation
Syntax
HS.GetCellRealData("POV",Var1)
Table 11-24 Syntax for GetCellRealData Function
Parameter | Description |
---|---|
POV |
A valid point of view. |
Var1 |
A variable that specifies if there is real data in the cell. |
Return Value
The possible return values depend on what is found in the cell:
-
If the cell contains real data, the data value is returned and the boolean value returned for Var1 is True.
-
If the cell contains no data, 0 is returned for the data value and the boolean value returned for Var1 is False.
-
If the cell contains derived data, the derived value is returned and the boolean value returned for Var1 is False.
Example
dData = HS.GetCellRealData("A#Sales.C1#Prod1",bIsRealData)
If bIsRealData = TRUE then
...
End If