How to fix this problem

please helpme to coorrect this problem

formula

CONCATENATE(
“TAGIHAN (”,
COUNT(
FILTER(
“COBA”,
IfS(
usersettings(“FUNGSI”)=“PENGAWASJAR1”,[ADMIN]=“CLEAR”,[PENGAWAS PEKERJAAN (NAMA)]=“PANDE NYOMAN WIRA”,))),")")

Hi @Wais_alqarni

Perhaps it is better to use AND or OR instead of IFS.
A sample of extraction using AND in the FILTER help is helpful.

3 Likes

It is true what @Takuya_Miyai Said, It is better to use always AND/OR expressions.

In this case I believe that your problem is just a synaxis problem.

Try by deleting this Coma

2 Likes