DOCUMENTATIONAPI REFERENCEAI-Link
DownloadsSupport
Loading search results...
Working with CubesCreating CubesModeling Cube MeasuresAdd Calculated MeasuresMDX ReferenceCDEC

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))