Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try below
Sum( If(TransactionDate = ServiceDate, Totals) {<Account = {'2000', '2004'}>} )
May be this
Sum({<Account = {'2000', '2004'}>} If(TransactionDate = ServiceDate, Totals))
try below
Sum( If(TransactionDate = ServiceDate, Totals) {<Account = {'2000', '2004'}>} )