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 |
Last updated