This function is used to define a scope of time in Measured Values.

 

Syntax

Range( <Start Member>, <End Member> )

Parameters

<Start Member> : A Date Member or Member Function

<End Member> : A Date Member or Member Function

Description

Returns a Group of consecutive Members starting at <Start Member> and ending at <End Member>

Examples

Total sales for January 2008 through March 2008:

    ( [Sum Sales], RANGE([January 2008], [March 2008]) )

 

Total sales starting one month back up until the current month:

    ([Sum Sales], RANGE(Prev([Time Month]),Current([Time Month)) )

See Also