Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It seems correct, use ' instead of "
count (DISTINCT{$<date_entree={'<>0'}>} Matricule)
/
count (DISTINCT TOTAL {$<date_entree={'<>0'}>} Matricule)
Let me know
Hi,
try this,
num(
count (DISTINCT{$<date_entree={"<>0"}>} Matricule)
/
count (DISTINCT TOTAL {$<date_entree={"<>0"}>} Matricule) ,'#,##0.00%'
)
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 " "
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 !
It does not work with the num.
It does not work with the ALL... I tried with the ' and the ", not better.
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??
=NUM(COUNT(DISTINCT {<date_entree= {'<>0'}>}Matricule) /COUNT(DISTINCT {<date_entree= {'<>0'}>} ALL Matricule),'#,##0.00%')
Hi,
try this.
num(
count (DISTINCT{$<date_entree={"<>0"}>} Matricule)
/
count ({$<date_entree={"<>0"}>} Matricule) ,'#,##0.00%'
)
hope it will help you.