Skip to main content
Version: I2023.3.0

CBOOL

Casts the value to a Boolean. Returns False for String or Numeric expressions that evaluate to zero, else returns true.

Syntax

CBOOL(Value_Expression)

Input Parameters

Value Expression

Return Value

Returns a Boolean.

Example

A calculated expression to detect if the current level of the Order Retail445 hierarchy is the root level.

NOT CBOOL([Order Date Dimension].[Order Retail445].currentMember.LEVEL_NUMBER)