Hey there,

I'm a bit confused with a conditionnal equation.

q2 is a list of numeric fields. Some are hidden (not ticked in q1).
In q3, I want to show the question only if there are more than 2 answer in q2 < 2015.

I'm using this equation:
countifop("<",2015,that.q2.value)

It seems to be working, but I count hidden field value as 0.

Is it possible to add an interval in this equation? Something like (countifop("<",2015,that.q2.value) && countifop(">",0,that.q2.value)) ?

Cheers.

What about just deducting the amount of empty/zero fields from the counting result?

That indeed should solve the problem. Gonna try on monday.

This equation is good indeed, thank you jelo
I'm displaying this in a question {(countifop("<",2015,that.q2.value)-countifop("<=",0,that.q2.value))} and get the attended value : 3
Then I add this filter in next question : ((countifop("<",2015,that.q2.value)-countifop("<=",0,that.q2.value))>2) but the question never show, even if the number is over 2.
Any idea why?

Just to let you know I 'solved' the problem, it might help someone in the future :

I created a hidden question calc1 with numeric field (betweet q2 and q3), and added this to default value : I finally added this condition in my q3 :
I'm curious to know why the equation ((countifop("<",2015,that.q2.value)-countifop("<=",0,that.q2.value))>2) doesn't work though.