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.