I currently have a table for all expenses against projects and a table for all budget line items against projects.
I use these tables are used to filter against a “project dashboard” section that depending on the project selected on a drop down shows all tasks, budget items and expenses.
I want to track expenses against budget line items on the budget line items table so i currently have the formula below for the column written as the following:
SumIf([Project Expenses].TOTAL,[Project Expenses].[Project Title]=[Project Budget].[Project Title] && [Project Expenses].[Budget Line Item]=[Project Budget].[Budget Line Item] )
the formula isn’t giving an error but I’m not getting any values in the columns… So I KNOW i’m doing something wrong haha
Any ideas? Am i using the sumif formula incorrectly?