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
please post your qvw as it seems to me that some of the answers should work