How to fix this problem

[Wais_alqarni]

please helpme to coorrect this problem

formula

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

[takuya_miyai]

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.

help.appsheet.com

FILTER()

Select rows of table or slice

[Juan_Camilo_Sie]

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