Upvote 1

COUNT IF function

Answered Leowhuiting 3 years ago

Hi, anyone know if I can add a countif function here, or any other function that can solve the similar problem?

Replies (1)

You can do something similar with data masters and events. In the expression builder use the filter and data count operators.

Here's an example. I've attached the JIM file also.

Add a data master with two fields "Color" and "Fruit" (see screenshot below)

Add a text object - just put COUNT for the text

On that text object add an 'On Page Load -> Set Value' event.

In the equation builder use data count, then filter. See screenshot below

When the page loads, the COUNT text field will show the count as defined by your filter. In my example it shows 2.



Leave a Comment
Attach a file