SUM not working for visibility condition

Hi,

I have an issue with the SUM value in the database, the filters don’t seem to work, in the example there are two records in a DB collection for year 2022 week 14 with a sum value of 3.98 (2 x 1.99):

However, when i use the SUM in a visibility of a text element, the filters dont seem to work, and instead SUMs up all the records not just the ones in the filter:

This should not display as the sum is less than 5, but it does!!!..Any ideas what i am doing wrong?

Regards.

I believe your issue is that you are using OR filters instead of AND.

Try setting the filters with AND. Condition X AND Condition Y.

Hi, Thank you for the response… but it doesn’t give me the option to chose AND or OR when press the “add another filter” hyperlink on a visibility filter.

Any other ideas, i am stuck?

Hi Joe,

Does that two records belongs to the currently Logged in user ( The user that you are viewing the app )? Because your filter has Logged in user’s>Orders>OrderValue>SUM.

Thank you

Hi, yes all three records are for the same user (the logged in user), however only two records are for week 14 (the filter)

It shows the correct value in magic text with the filters, but not when as a visibility filter, so i am now thinking that it is an actual bug in Adalo?

Try deleting the button and refresh the tab and add the button again and add the condition and see if you still see this issue! If it is the best would be Submitting a support ticket!