CDBL

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

Syntax

CDBL(Value_Expression)

Input Parameters

Value Expression

Return Value

Returns a Double.

Example

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

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