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

CINT

Casts the value to an integer. Returns Null if the cast is invalid.

Syntax 

CINT(Value_Expression)

Input Parameters

Value Expression

Return Value

Returns an integer.

Example

Parse the right 4 characters from the member's name and convert to an Integer

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