ISSTART() function

Returns values for when a dimension item starts

🗒️ Description

The IsStart function is to be used alongside the Start/End functionality within dimensions. When Start/End functionality is switched on for a dimension, each item will have a start or end date.

IsStart will return the value of 1 for the period which corresponds with each item's Start period. Otherwise it will return the value 0.

✏️ Syntax & variables

It can be chained with other functions or values eg

✅ Expected result & examples

Case 1: Dimension with start/end enabled

For a block with a dimension which has start/end dates enabled, then IsStart() will return 1 or 0 based on when each item has it’s start value.

• If there is no start value (start = Blank), we put 1 in the first time period
• If there is a start value, we put 1 in the relevant time period

See below for expected result

Other CasesDimension with start / end date not enabled

IsStart does not apply to dimensions without start/end dates. Therefore for items on a dimension without start/end dates:

• Return 1 in the first time period for all items
• Return 0 for all other time periods

Blocks with no dimensions

If a block has no dimensions, and IsStart() is used in a formula:

• Return 1 in the first time period
• Return 0 for all other time periods