How to sum multiple conditions in appsheet

[Deryck]

SUM(SELECT(Absensi Instruktur[Fee],AND(
[_THISROW].[Nama Training]=[Nama Training],
[_THISROW].[Batch]=[Batch],
[_THISROW].[Nama Instruktur]=[Nama Instruktur],
[_THISROW].[Kelas]=[Kelas],
[_THISROW].[Bulan]=[Bulan],
[Status]="ACCEPTED"),TRUE))

this formula is not working, it's not filtering status.

how i can make this statement [Status]="ACCEPTED" working

[WillowMobileSys]

There doesn't seem to be anything wrong with the exception.  Maybe you are not implementing it in the way you really need to?

The way you presently have it implemented the row MUST meet all 6 criteria to be selected and included in the SUM.

---

@Deryck wrote:

how i can make this statement [Status]="ACCEPTED" working

---

By this, maybe you mean you want the row included if the Status = "ACCEPTED"...OR...meets the other 5 criteria?  If so, then you expression would be something like this:

SUM(SELECT(Absensi Instruktur[Fee], 
           OR(
              [Status]="ACCEPTED",
              AND(
                  [_THISROW].[Nama Training]=[Nama Training],
                  [_THISROW].[Batch]=[Batch],
                  [_THISROW].[Nama Instruktur]=[Nama Instruktur],
                  [_THISROW].[Kelas]=[Kelas],
                  [_THISROW].[Bulan]=[Bulan]
             )
          )
))

NOTE:  The TRUE portion is not needed.

I hope this helps!

[Deryck]

no, i do implementing like what i want.

i want showing sum at Group aggregate when [Status]="ACCEPTED"

[Deryck]

can someone here help me