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.