Conditional Rollup

[Dolapo_Amusan]

Happy new year Gliders!

I have seen some answers about conditional rollups, but I strongly believe it should be a feature request.Looking at this table I have, I wish to easily do a count of how many times my lookup returned the value “0” for example.

Pending (if and) when it is a feature, what is the workaround to get this data?

[Robert_Petitto]

Any time you want a conditional relation/Rollup, create the condition first with an ITE column.

If [COLUMN] = 0 then 1 (or TRUE) else 0 or empty (or FALSE)

Then Rollup by doing a sum of 1s (or a count of trues)

[ShantanuIyengar]

Same logic for sum as well!
If the condition is True
Then use the value or else use 0
And then you can sum it all up!

[Robert_Petitto]

Right. A native conditional relation has been requested many times here on the forum, but until it happens, it requires the use of a combination of Glide columns.

Upvote:

Conditional Relations

I know myself and others have made this case before, but I’d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, let’s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. In…

[ThinhDinh]

If you want a one-column solution then I have this experimental code to help.

The link is:

https://thinhdinhlca.github.io/count-occurrences-in-array/