ISSTART() function

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.

It can be chained with other functions or values eg

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

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

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