5 Replies Latest reply: Feb 14, 2018 11:56 AM by Melissa Pluke RSS

    Sum if Date For another field qualifies

    Melissa Pluke
      All Inclusive DateDate TypeID
      9/19/2017Group12345

       

      Group DateAmountIDGroup ID
      10/24/17$50012345

      56234

      9/19/17$4001234586539

       

      Hi all,

      I have two tables, TableA with All Inclusive Date, Date Type, and ID in it. TableB with Group Date, Amount, ID and Group ID in it.

       

      I am trying to create a table in the UI that includes the month of the all inclusive date, and the sum of the amount if the group date is in the same month as the all inclusive date. So in the case above, the sum would be $400. Any ideas on how to do this?

       

      Thank you!