Count with condition

[vbravomo]

Hi everybody,

I have a big problem. I have a table with two dates, a column with the difference between those dates, and a column with telephone numbers.

I've tried this code but returns me a wrong result Count(Distinct{<Tiempo={">=0"}, Tiempo={"<=30"}>}CAR_Telefono)

Good results: 14690

Results I get: 20530

Please help me.

Thanks

[OmarBenSalem · Accepted solution]

try :

Count(Distinct{<Tiempo={">=0<=30"}>}CAR_Telefono)

[vbravomo]

It Works, thank you