Find student unpaid fee

[Muhamad_Shuhaib]

I want formula to find/filter the names of students who have not paid their fees by month based on the data of students who have finished paying their fees. Pless help me.

I have table name "Data Student" and "Student Fees"

[Firdaus_AG]

State the rows involved for both tables

[Muhamad_Shuhaib]

Data Student’s table: IDStudent, Class etc.

Student Fee’s table: IDStudent, class, month and year

[Firdaus_AG]

Try watch this video https://youtu.be/YKE9IKXzuSM?si=5j6HGrEDD-mrl-fU

[Aurelien]

Hi @Muhamad_Shuhaib 

---

@Muhamad_Shuhaib wrote:

I want formula to find/filter the names of students who have not paid their fees by month based on the data of students who have finished paying their fees.

---

---

@Muhamad_Shuhaib wrote:

Data Student’s table: IDStudent, Class etc.

Student Fee’s table: IDStudent, class, month and year

---

I would suggest to add a column IDStudentFee to your table Student Fee. I would suggest also to remove the column "class" as it is already existing in the table Data Student.

I assume you have a column [due] (type Decimal or Price or Number) and [paid] (type Yes/No) in your table Student Fee. Assuming you have it:

Then, add a virtual column [_result] with type List of Ref, Source table Data Student, with expression:

SELECT(Student Fees[IDStudent],
AND(
  MONTH(NOW())=[month],
  YEAR (NOW())=[year],
  NOT([paid])
)

For reference:

SELECT() - AppSheet Help

Use virtual columns - AppSheet Help