Hi, anyone know if I can add a countif function here, or any other function that can solve the similar problem?
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.
Replies have been locked on this page!
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.
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.
Replies have been locked on this page!