count statement with 2 conditions

[samuel_brierley]

I have the following formula and for the life of me cant work out whats wrong with it. it produces a number the number is not correct.

pretty obvious but for clairty its supposed to count how many cars that have a length between 10 and 6 meters. Ive tried both ways i.e 10m first and then 6 vice versa.

thanks for any help

count({$<Length = {'<10'},Length = {'>6'} >} Length)

[#2]

count({$<Length={">6<10"}>}'ID')

[#3]

Hi,

Try like this

  =Count(Distinct {<Length={">=6<10"}>}Length)

Regards

Kumar

[VishalWaghole]

Hello samuel,

Please try this, hope this will work for you.

=Count({<Length = {'<6','>8'}>}Length)

- Regards,

Vishal Waghole.

[er_mohit]

Try this

=Count({<Length = {">6<10"}>}Car)

or

=Count({< Car={"=Count({<Length = {">6<10"}>}Car)"}>}Car)

[amit_saini · Accepted solution]

Hi Samuel,

Please try this:

=Count({<Length = {">6<10"}>}Cars)

Thanks,

AS

[#7]

hi

try this

count({<Length={">=6<=10"}>}Cars)

[samuel_brierley]

thanks for the help