Skip to main content
Version: I2024.1.3

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)