Count and Sum

[Muhamad_Shuhaib]

Table ID CUTI 1 ☝️

Table CUTI 2 ☝️

Pless help me to make a count & sum formula, I want to find the amount of teacher leave according to the criteria "because of holidays" in table "cuti 2". The display of the amount of leave will be displayed in the appsheet table "id cuti 1". I also want to calculate the amount of teacher leave according to the criteria "because of holidays".

[TeeSee1 · Accepted solution]

If I understand you correctly try...

For the total number of holidays per teacher

COUNT(
 FILTER(
  "CUTI 2",
  [ID TEACHER] = [_THISROW].[ID TEACHER]
 )
)

for each of the reasons per teacher (create a separate column for each reason)

COUNT(
 FILTER(
  "CUTI 2",
  AND(
   [ID TEACHER] = [_THISROW].[ID TEACHER],
   [because of holidays] = //here set a value for the reason//
  )
)

[Muhamad_Shuhaib]

Yes work correctly, tq sir for your helped.