Contar distintos

[williamdame]

Olá,

Não estou conseguindo obter a quantidade correta de propostas distintas referente a uma base. Eu sei que a quantidade é 10, porém sigo obtendo 11, imagino que esteja contando alguma célula vazia, em brano ou nula, mas mesmo assim não consigo setar para ignorar. Envio imagens e o código para ver se conseguem me ajudar.

count(

{< [Cod. Proposta (AFPRF)] -= {'*', ' ', ''}, [Situação] = {'Entregue'}>}

distinct
if ( [Data de Entrada (AFPRF)] >= [Data Envio], [Cod. Proposta (AFPRF)],0))

[MEBG93]

Try this:

count(

{< [Cod. Proposta (AFPRF)] -= {"$(=isnull([Cod. Proposta (AFPRF)]))"}, [Situação] = {'Entregue'}>}

distinct
if ( [Data de Entrada (AFPRF)] >= [Data Envio], [Cod. Proposta (AFPRF)],0))

[williamdame]

Thanks @MEBG93 , but still  can´t get this right. 

I have no idea about what it is counting. I don´t want to insert the " - 1" at the end because it may be a problem in the future with filters. 

[williamdame]

Looks like it ´s counting blanks, or nulls, our emtpy cells, but I´ve tryed with set analyses and still nothing

[MEBG93]

Try to use the if condition first and then apply set analysis, like this:

if ( [Data de Entrada (AFPRF)] >= [Data Envio],

count({< [Cod. Proposta (AFPRF)] -= {"$(=isnull([Cod. Proposta (AFPRF)]))"}, [Situação] = {'Entregue'}>}

distinct [Cod. Proposta (AFPRF)],

0))

Hope it helps

[williamdame]

unfortunaltely It´s still keep counting the other value. I can solve it when i´m not using KPI, just selecting to not use o values.

[Oleg_Troyansky]

Hi,

I'd be happy to take a look and help, but I need to understand the question. Can you ask it again in English?

Cheers,

[williamdame]

Sure!!

I can´t get the right amount of "Liberadas" and "Inclusões". It is counting always 1 more then it should. The pictures show 11, but the right is 10. I think it is counting a blank cell, or null, but still I can´t set SENSE to ignore it. 

[MEBG93 · Accepted solution]

What about:

if ( [Data de Entrada (AFPRF)] >= [Data Envio],

count({< [Cod. Proposta (AFPRF)] = {"$(=len([Cod. Proposta (AFPRF)])>0)"}, [Situação] = {'Entregue'}>}

distinct [Cod. Proposta (AFPRF)],

0))

[MEBG93]

@williamdame did it work?