Sum if with set modifier

[akuttler]

Hello, I am trying to sum totals where transaction date is equal to service date.

The expression below works:

Sum(IF(TransactionDate = ServiceDate, Totals))

However I need to add a set modifier:

Sum(IF(TransactionDate = ServiceDate,{<Account = {'2000', '2004'}>} Totals))

But it gives me "error in expression"

Not sure where to place the set modifier in this scenario.

[sunny_talwar]

May be this

Sum({<Account = {'2000', '2004'}>} If(TransactionDate = ServiceDate, Totals))

[sunilkumarqv · Accepted solution]

try below

Sum(  If(TransactionDate = ServiceDate, Totals)  {<Account = {'2000', '2004'}>}  )