Filter function works with only 3 conditions

[sjagnade]

Hi,
I’m trying to filter data from SharePoint list with 4 conditions and sum one of the column.

Here is my formula

Sum(filter(datasource, condition1 && condition2 && condition3 && condition4), colx)

It doesn’t work. If I remove one condition it works, it shows the sum.

Is there any restrictions on no of conditions with filter function or can you help on this? Thanks

[Jeff_Thorpe]

I am not aware of limit with conditions. Are you sure that you have items in the SharePoint list that meet all four conditions? If so, how large is your list? I ask because I don't think the Sum() is delegable in SharePoint, so it could be factor in your results.

You can also write the formula like this:

Sum(filter(datasource, condition1, condition2, condition3, condition4), colx)

[v-xida-msft]

Hi @sjagnade ,

Could you please share more details about your formula?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please consider modify your formula as below:

Sum(
    Filter(
           datasource, 
           condition1,
           condition2,
           condition3,
           condition4
    ), 
    colx
)

Please also check if you have specified proper filter condition within your Filter function. More details about Filter function, please check the following article:

Filter function

Best regards,