Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis using less than issue

I need to count the number of items that have a duration of less than 259200.  I am trying this using set analysis but I am struggling.

Need to count the field "number", If "inc_business_duration" is equal to or less than 259200.

No matter what I try I cannot seem to get this one right.

3 Replies
sunny_talwar

May be this:

Count({<inc_business_duration = {'<=259200'}>}number)

sunny_talwar

Or this:

=Count(If(inc_business_duration <= 259200, number))

maxgro
MVP
MVP

count({$ <inc_business_duration={"<=259200"}>} number)