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