Need Help - Custom Collections filter not working (Adalo bug?)

I have a collection with credit and debit amounts. The debit amounts need to be approved by someone. Here is what my Transaction collection looks like

ID, Amount, Type, Valid
1, 5000, Credit, True
2, 2000, Debit, True
3, 4000, Debit, False
4, 1000, Debit, True

I want to sum only the records where Valid is True.

However, my custom filter has an option to choose a column but does not allow me to specify what the value should be. Is this a bug in Adalo or my naivety?

Here is a screenshot

Anyone has an idea what I am doing wrong here?

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.