Questions on DATA

Ask for Help
1

Good night people.

First time here in the Community.

I have a question about Glide’s DATA:

  1. 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).

  1. PROBLEM:
    . 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.

  2. 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.

2

In the Glide Editor you could try switching the column type of “Inactive” and “That did not pay” to a number format. That should allow the rollup to perform a sum.

3 Likes
3

Create an If Then Else column which COLUMN “INACTIVE is not INACTIVE then 1, and COLUMN DID NOT PAY is not DID NOT PAY then 1. So you can do what @Eric_Penn said and use the rollup to sum this values

3 Likes
4

Thanks guys!

1 Like