How can I calculate a MAXIFS

Hi ya! I have a column in my database with numbers that range between 200 and 299 and 500 and 599.

Like this:

I want to return the max value in the 200 series (205) and the max value from the 500 series (502). This is easy to do in excel or sheets using two MAXIFS functions (one for the 200s and one for the 500s).

Any ideas on how to do this in Bubble? Much appreciated!

To return the MAX value of the first series (200) do:

Search for Data (constraint for numbers < 500): each item number :max

To return de MAX value of the second series (500) do:

Search for Data each item number :max

Thank you! Appreciate you taking the time to help. :grinning:

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.