Formula that uses filter bar

I am trying to use a formula to calculate the sum of a score based on a filtered item. I want use the filter bar and based on the filter selection of “category” the formula will deliver the sum of the score for that filtered category.

Hey @Joe_Ross!

The doc you linked is not available to view publicly. But if I understand you right, you want to apply the filter from the filter bar and then use the remaining subset of rows as a basis of your formula. For this to work you have to make a view and add those filters to a view, not the base table. Then you can reference your view in the formula, and it will only give you the filtered rows to calculate over. With base tables (the ones that you originally created as new tables) it’s different: no matter the filters, referencing a table in your formula always gives you the full set of rows.

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