Good night people.
First time here in the Community.
I have a question about Glide’s DATA:
- Imagine the scenario below:
. I have the STUDENT TIME VALUE column and I need to know the teacher’s salary in the month.
So far, easy: we generated a ROLLUP column adding all the STUDENT TIME VALUE of all students.
. But I have to remove the INACTIVE students (COLUMN “INACTIVE” - CHOICE) and “THOSE WHO DID NOT PAY” (COLUMN DID NOT PAY - SWITCH).
. I can get the values of the INACTIVES and the ones THAT DID NOT PAY with new IF type columns.
. BUT I CANNOT, ON THE DATE, ADD THE VALUES OF “INACTIVE” AND “THAT DID NOT PAY” WITH ROLLUP COLUMNS. ONLY THE OPTION OF (count OR count unique) APPEARS TO ME.
THEREFORE, I CANNOT, ON THE DATE, MAKE THE CALCULATION (MATCH TYPE) - IN A NEW COLUMN - BELOW:
→ TOTAL VALUE HOUR STUDENT - SUM OF INACTIVES - SUM OF THOSE WHO HAVE NOT PAID.
I do not know if i was clear.
But thank you very much!
Marcelo Grecco - Rio de Janeiro - Brazil.