IsBlank

Syntax

IsBlank(Branch:VariableName)

Description

The IsBlank function returns True if there is no expression entered for the named Branch:VariableName.  Note: if there is an expression entered for a parent scenario (or Current Accounts), IsBlank will be false.

Examples

If( IsBlank(Central Reservoir:Top of Conservation), Central Reservoir:StorageCapacity, Central Reservoir:Top of Conservation)

If there is no expression for Top of Conservation, get the value of Storage Capacity, otherwise, use value of Top of Conservation.