Using the CountIf function

Applies to Infiniti v8.1 or later


The CountIf function will return the number of items that match the parameters set out in the formula. This particular function is commonly used with data source questions where there is a need for calculations once a specific threshold has been reached.

Example 1

CountIf("a|b|c", "b")

The formula would return a result of one.

Example 2

CountIf([Q1], "High Risk")

This will return the amount of High Risk’s that are present in [Q1].


Related Articles





CountIf function