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:

Syntax

HS.GetCellRealData("POV",Var1)

Table 57. 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