Skip to main content

CDEC

Casts the value to a Decimal number. Returns Null if the cast is invalid.

Syntax​

CDEC(Value_Expression)

Input Parameters​

Value Expression

Return Value​

Returns a Decimal number.

Example​

Return the right 4 characters from the member's name as a Decimal.

CDEC(RIGHT([Order Date Dimension].[Order Retail445].currentMember.NAME, 4))