Calculate the sum of data from Sharepoint, filtering by users' email

Hi All,

I am struggling with the formula below.

There are two columns in the Sharepoint list: "Data Collection", "Ranking" and "Calculate Ranking"

"Ranking" stores a number, and when it meets a specific condition, times 1, and the result will show in "Calculate Ranking"

So "Ranking" is a number field, and "Calculate Ranking" is a calculated field. The data type of both columns is "Number"

I want to add a text field in Power App that calculates the total "Calculate Ranking" of the user filling in the form.

Here is the formula:

Sum(Filter('Data Collection', 'Modified By'.Email = User().Email, 'Calculated Ranking'))

However, it is not working with the below warning:

Expected Number. We expect a number at this point in the formula.

It would be appreciated if you can solve this. Thanks a lot.

Helpful resources