Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
Count({<inc_business_duration = {'<=259200'}>}number)
Or this:
=Count(If(inc_business_duration <= 259200, number))
count({$ <inc_business_duration={"<=259200"}>} number)