2 Replies Latest reply: Jul 27, 2018 3:36 AM by sunil kumar RSS

    Sum if with set modifier

    Ashley Kuttler

      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.