Distinct Count with If

[#1]

Hi All,

I am struggling to convert the expression =Count(If(Enroute>=0,[Truck Reg],0)) into one which produces a distinct count of the field Truck reg whenever the condition Enroute>=0 is met.

Can someone assist with a tweak.

Thanks

[Emmanuelle__Bustos]

Have you tried

=If(Enroute>=0, Count([Truck Reg]),0)

[#3]

Hi Emmanuelle,

For some reason reason, the app doesn't quite like it and it produces zero, where as my first expression produces 563

Thanks

[joggiek]

Try this

=Count(Distinct(If(Enroute>=0,[Truck Reg],0)))

[Emmanuelle__Bustos]

If your first expression is working then add Disctinct:

=Count(Distinct(If(Enroute>=0,[Truck Reg],0)))

[jerem1234]

Why not set analysis?

=Count({<Enroute = {'>=0'}>} distinct [Truck Reg])

Hope this helps!