COUNT

The COUNT function counts the number of items in a range.

Syntax

COUNT(value1, ...valueN?) - > number

Arguments

Arguments	Datatype	Description
value1	Node reference	The first node or number to be counted. This is a required argument.
...valueN?	Node reference	The additional nodes or numbers to be counted. These are optional arguments.

Example

Consider a scenario where you want to calculate the number of periods for which the simulations are performed for a [Sales] node. That is if simulation period is between July and September, the result should be 3.

Sim.Months

July

August

September

In order to calculate the number of periods, the following formula should be written in the [COUNT] node:

COUNT ([Sales].SIM_PERIODS)

Refer [NODE].SIM_PERIODS to know more.

Result

COUNT

3