Hi community,

I have this problem, dealing since yesterday with how to solve this thing:

I have a table with differente projects and I want to sum all the items with that category, and in another column to sum only if each row has a TRUE on its checkbox. Is like having different scenarios for the same budget.

I could sum all the items with the same project but I can’t realize how to add a “if” inside that formula, or if I have to change the formula.

Here is my formula:

[Per project].Filter(Iniciativa=thisRow.Iniciativa).Cost.Sum()

And here you can see my tables:

Any ideas? I feel Filtering is a very common problem, despite the documentation and the tutorial, I always have probles with this nice formula.

Thanks!