isNull is typically used as part of logic expressions to check whether a
metric value is null. 1 means true whereas 0 means false.
INT isNull(ATTR
A)
Table 1. isNull Function examples
| Expression |
Result |
isNull(nullInt())
|
1 (division by zero always results in null, which
is converted into (1) for true.) |
IsNull([Cell]![{Neutral.TCH.traffic}] )
|
Returns 1 if Neutral.TCH.traffic
is null or 0 if not null. |
IsNull([Cell]![ave_avail_full_TCH] +
[Cell]![{Nokia.Resource_Availability.ave_non_avail_TCH}]) ? "100":
(([Cell]![ave_avail_full_TCH] +
[Cell]![{Nokia.Resource_Availability.ave_non_avail_TCH}]) = "0" ?
"100" : ( [Cell]![ave_avail_full_TCH] / (
[Cell]![ave_avail_full_TCH] +
[Cell]![{Nokia.Resource_Availability.ave_non_avail_TCH}] )) * 100 )
|
This means
if
'[Cell]![ave_avail_full_TCH] +
[Cell]![{Nokia.Resource_Availability.ave_non_avail_TCH}]'
Is null, then calculation returns 100 else if
'[Cell]![ave_avail_full_TCH] +
[Cell]![{Nokia.Resource_Availability.ave_non_avail_TCH}]'
Is zero, then calculation returns 100 else the calculation returns the
calculation of (A/ (B+C))*100.
( [Cell]![ave_avail_full_TCH] /
( [Cell]![ave_avail_full_TCH] +
[Cell]![{Nokia.Resource_Availability.ave_non_avail_TCH}]
)) * 100
|