Help with IF AND SUM expression

[spicyChick3n]

Hi, I need help with a supposedly simple expression but I can’t seem to figure this out…

• TABLE 1: expense type (text)
• TABLE 2: transition list with a reference to the expense type (enumlist) and expense date (number with initial display to be month of today)
• TABLE 3: summary by expense type (text) and month (number)

Expression: if(and([Month]=Transactions[Expense Date],[Expense Type]=Transactions[Expense Type]),sum(Transactions[Actual Cost]),“”)

Errors:

Cannot compare Number with List in ([Month] = Transactions[Expense Date])
Cannot compare Ref with List in ([Expense Type] = Transactions[Expense Type])

How can I rewrite this expression?

[scott192]

:if(and(IN([Month],Transactions[Expense Date]),IN([Expense Type],Transactions[Expense Type])),sum(Transactions[Actual Cost]),“”)

[spicyChick3n]

Thank you @scott192 ! But now my chart doesn’t show any data - any idea why? i’ve also checked the data table - everything is zero. but for sure i have transactions there to build up the sum