# Questions on DATA

**URL:** https://community.glideapps.com/t/questions-on-data/22420
**Category:** Ask for Help
**Created:** [February 8, 2021, 3:23pm UTC](https://community.glideapps.com/t/questions-on-data/22420 "2021-02-08T15:23:12Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![mgrecco71](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgrecco71/32/20223_2.png) [@mgrecco71](https://community.glideapps.com/u/mgrecco71)
#### Post date: [February 8, 2021, 3:23pm UTC](https://community.glideapps.com/t/questions-on-data/22420/1 "2021-02-08T15:23:12Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [February 8, 2021, 11:30pm UTC](https://community.glideapps.com/t/questions-on-data/22420/2 "2021-02-08T23:30:30Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [February 9, 2021, 2:00pm UTC](https://community.glideapps.com/t/questions-on-data/22420/3 "2021-02-09T14:00:21Z")

</div>

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

---

<div class="post-metadata">

### Author: ![mgrecco71](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgrecco71/32/20223_2.png) [@mgrecco71](https://community.glideapps.com/u/mgrecco71)
#### Post date: [February 9, 2021, 2:55pm UTC](https://community.glideapps.com/t/questions-on-data/22420/4 "2021-02-09T14:55:42Z")

</div>

Thanks guys!

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/questions-on-data/22420/5 "2024-01-17T16:53:26Z")

</div>