topic Re: Syntax with function Count in Francophones

Syntax with function Count

Fri, 07 Mar 2014 15:07:02 GMT

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)

Thanks in advance,

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

alexandros17 — Fri, 07 Mar 2014 15:09:30 GMT

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

PrashantSangle — Fri, 07 Mar 2014 15:12:45 GMT

Hi,

try this,

num(

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

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

)

Re: Syntax with function Count

MK_QSL — Fri, 07 Mar 2014 15:21:29 GMT

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

Fri, 07 Mar 2014 15:25:16 GMT

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

Fri, 07 Mar 2014 15:25:59 GMT

It does not work with the num.

Re: Syntax with function Count

Fri, 07 Mar 2014 15:27:42 GMT

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

Re: Syntax with function Count

PrashantSangle — Fri, 07 Mar 2014 15:37:56 GMT

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

MK_QSL — Fri, 07 Mar 2014 15:40:54 GMT

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

Re: Syntax with function Count

PrashantSangle — Fri, 07 Mar 2014 16:16:19 GMT

Hi,

try this.

num(

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

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

)

hope it will help you.

Re: Syntax with function Count

maxgro — Fri, 07 Mar 2014 21:15:56 GMT

please post your qvw as it seems to me that some of the answers should work