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([nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}]+
[nUtranCell]![{nUtranCell.N.User.RRCConn.Active.DL.Max}]) ? 100:0
|
Returns 100 if
IsNull([nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}]+
[nUtranCell]![{nUtranCell.N.User.RRCConn.Active.DL.Max}]) ? 100:20
is null or 0 if not
null. |
IsNull([nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}]+[nUtranCell]!
[{nUtranCell.N.User.RRCConn.Active.DL.Max}]) ?100 : ([nUtranCell]!
[{nUtranCell.N.User.RRCConn.Active.UL.Max}]+[nUtranCell]![{nUtranCell.N.User.RRCConn.Active.DL.Max}]
= 0) ?100 : (([nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}] /
([nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}]+[nUtranCell]!
[{nUtranCell.N.User.RRCConn.Active.DL.Max}])) * 100)
|
This means, if '[nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}]+[nUtranCell]!
[{nUtranCell.N.User.RRCConn.Active.DL.Max}]'
is null, then calculation returns 100 else
if '[nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}]+[nUtranCell]!
[{nUtranCell.N.User.RRCConn.Active.DL.Max}]'
is zero, then calculation returns 100, else
the calculation returns a value of
(A/(B+C))*100. ([nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}] /
([nUtranCell]![{nUtranCell.N.User.RRCConn.Active.UL.Max}]+[nUtranCell]!
[{nUtranCell.N.User.RRCConn.Active.DL.Max}])) * 100
|