10 Replies Latest reply: Mar 7, 2014 4:16 PM by Massimo Grossi

# Syntax with function Count

Hello everyone.

I would like percentages rather than values. So I tried to use the TOTAL with function Count but it does not work.

Does anyone have an idea?

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

/

count (DISTINCT TOTAL {\$<date_entree={"<>0"}>} Matricule)

Emmanuelle

--------------------------------------------------------------------------------------------------------------------------------------

Bonjour tout le monde,

J'aimerais avoir des pourcentages plutôt que des valeurs. Donc j'ai essayé d'utiliser le TOTAL mais cela ne marche pas.

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

/

count (DISTINCT TOTAL {\$<date_entree={"<>0"}>} Matricule)

Quelqu'un aurait-il une idée ?

Emmanuelle

• ###### Re: Syntax with function Count

It seems correct, use ' instead of "

count (DISTINCT{\$<date_entree={'<>0'}>} Matricule)

/

count (DISTINCT TOTAL {\$<date_entree={'<>0'}>} Matricule)

Let me know

• ###### Re: Syntax with function Count

Try USING ALL instead of TOTAL...

count (DISTINCT{\$<date_entree={'<>0'}>} Matricule)

/

count (DISTINCT ALL {\$<date_entree={'<>0'}>} Matricule)

Try with both single and double quotes...

i.e. ' ' and " "

• ###### Re: Syntax with function Count

It does not work with the ALL... I tried with the ' and the ", not better.

• ###### Re: Syntax with function Count

It does not work either...

I think it comes from the function COUNT with DISTINCT and TOTAL. But I do not know how to express it otherwise !

• ###### Re: Syntax with function Count

Hi,

try this,

num(

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

/

count (DISTINCT TOTAL {\$<date_entree={"<>0"}>} Matricule) ,'#,##0.00%'

)

• ###### Re: Syntax with function Count

It does not work with the num.

• ###### Re: Syntax with function Count

Hi,

individually did you get  value for your expression,

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

and

count (DISTINCT TOTAL {\$<date_entree={"<>0"}>} Matricule)

Your date_entree field contain date value??

• ###### Re: Syntax with function Count

=NUM(COUNT(DISTINCT {<date_entree= {'<>0'}>}Matricule) /COUNT(DISTINCT  {<date_entree= {'<>0'}>} ALL Matricule),'#,##0.00%')

• ###### Re: Syntax with function Count

Hi,

try this.

num(

count (DISTINCT{\$<date_entree={"<>0"}>} Matricule)

/

count ({\$<date_entree={"<>0"}>} Matricule) ,'#,##0.00%'

)