# ISACTIVE() function

Returns values for when a dimension item is valid

Rob Markwell

Last Update 4 месяца назад

The IsActive 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.

IsActive will return the value of 1 for all periods between the start and end dates. Otherwise it will return the value 0

**Case 1: Dimension with start / end dates**

For a block which has a dimension which has start/end dates enabled then IsActive() will return 1 or 0 for each of the items in each month based on the start / end dates. See below for the expected result for an indicator formula set to IsActive()

**Other cases**

**Dimension with start / end date not enabled**

IsActive does not apply to dimensions without start/end dates. Therefore for items on a dimension without start/end dates, we can return 1 for all items

**Blocks with no dimensions**

If a block has no dimensions, and IsActive() is used in a formula, we can assume the value is always 1