Expression: Missing Values

FastStats handles Missing values in the context of expressions and operators.

IsMissing

 

Determines whether a value is Missing, returning true or false

 

IsMissing([Numeric Field])

 

e.g. If(IsMissing([Cost]),"No Value Present", Value Present")

 

When displayed on a Data Grid if an entry is missing output the words No Value Present if a value is present output the words Value Present

MissingValue

Returns a missing numeric value for specified entries

 

MissingValue()

 

e.g. If([Number of Bookings]<=0,MissingValue(), Value of Booking/Number of Bookings)

 

When displayed on a Data Grid output a blank for those entries with no bookings and an average per booking figure for those entries with 1 or more bookings

NotMissing

Determines whether a value is not missing, returning true or false

 

NotMissing([Numeric Field])

 

e.g. If(NotMissing([Value of Booking]),Value of Booking, 100)

 

When displayed on a Data Grid if a value is present (i.e. not missing) then output that value otherwise output the figure 100

Expressions that reference Missing values are evaluated as follows:

Expression

 

Result

 

Missing + Missing

 

Missing

Value + Missing

 

Value

Missing - Missing

Missing

 

Value - Missing

 

Value

Missing - Value

 

-Value

Missing * Value

 

Missing

Missing / Value

 

Missing

Value / Missing

 

Missing

Missing / 0

 

Missing

Missing % Value

Missing

 

Value % Missing

 

Missing

Missing % 0

 

Missing

Missing ^ Value

Missing

 

Value ^ Missing

 

Missing

Value ^ Missing

Missing

 

Value > Missing

true

 

Missing > Value

 

false

Missing > Missing

false

 

Value < Missing

 

true

Missing < Value

 

false

Missing < Missing

 

false

Value >= Missing

 

true

Missing >= Value

 

false

Missing >= Missing

 

false

Value <= Missing

true

 

Missing <= Value

false

 

Missing <= Missing

 

false

Value = Missing

 

false

Missing = Missing

 

false

Value <> Missing

true

 

Missing <> Missing

 

false

 

Function(Missing)

All single parameter functions except IsMissing() evaluate to Missing

 

 

See also - Expressions Overview