I need help.
I'm trying to count how many times a person got "YES".
However, the person's name repeats on different dates, depending on how the classroom is called.
There are 2 tables:
DB_PESSOAS and DB_CHAMADA
It is necessary to repeat the PERSON_NAME, as it links to another table that controls the CALL DATE.
I'm not getting the desired result.
See the formula:
COUNT(SELECT(DB_CHAMADA[NOME_PESSOA],
AND([NOME_PESSOA]=[_THISROW].[NOME_PESSOA],
[PRESENCA]='SIM'),
true)
)
Solved! Go to Solution.
Friendยดs
I solved this problem...see:
COUNT(FILTER("DB_CHAMADA",
AND(([_THISROW] = [NOME_PESSOA]),
([PRESENCA]="SIM"))))
I based on formula REF_ROWS.
tks everyone
The last parameter of a SELECT statement set TRUE ELIMINATES any duplicates. If you want to retain duplicate results, you should set it to FALSE.
Hello,
I try this form before post this question, dont work ( instruction TRUE or FALSE)
Unfortunity return NOTHING or ZERO or hight values.
Shoud return value =4
First try checking if the SELECT statement returns a list. And check whats on that list.
If it is not what your expecting there's probably something wrong you sour SELECT condition.
Friendยดs
I solved this problem...see:
COUNT(FILTER("DB_CHAMADA",
AND(([_THISROW] = [NOME_PESSOA]),
([PRESENCA]="SIM"))))
I based on formula REF_ROWS.
tks everyone
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |