Formula for select all if child column is blank

i have projects and items
and i make report
select project column then select item column to get total for project and item
i want formula to work when item is blank to select all items for selected project

Hi there! I didn’t understand your question.

Would you be able to write it natively in your language and then use google translate? Perhaps that would clear any confusion.

in report table
i want formula to clalculate all set items if set items is blank

Data.Filter(Project=thisRow.Projectand [Set items]=thisRow.[Set items]).Value.Sum()

if set items is blank
select all set items in the project for selected project

in report table
third row project is selected but set items not selected i want formula to calculate all set items and return 80 instead of 0

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