Using the CountIf function

Applies to Infiniti v8.1 or later
 

Purpose

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

 

 

Keywords

 

CountIf function