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
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.
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!
no, i do implementing like what i want.
i want showing sum atGroup aggregate when [Status]=“ACCEPTED”
