Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried
=If(Enroute>=0, Count([Truck Reg]),0)
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
Try this
=Count(Distinct(If(Enroute>=0,[Truck Reg],0)))
If your first expression is working then add Disctinct:
=Count(Distinct(If(Enroute>=0,[Truck Reg],0)))
Why not set analysis?
=Count({<Enroute = {'>=0'}>} distinct [Truck Reg])
Hope this helps!