COUNTLISTIF

The COUNTLISTIF function in Shedmate counts the number of items in a list that meet a specific condition.

Syntax:

COUNTLISTIF(Logical expression)

Parameters:

Logical expression: Logical expression that will be validated to obtain the value.

Usage examples:

Count how many front walls we have:

COUNTLISTIF(shedresult.walls.*.wallidentifier="Front")

Count how many rollerdoors are located in the front wall:

COUNTLISTIF (shedresult.rollerdoors.*.wallidentifier="Front")

Count how many SERIES A rollerdoors are located in the front wall:

COUNTLISTIF(AND(shedresult.rollerdoors.*.wallidentifier="Front",shedresult.rollerdoors.*.seriesname="Series A"))