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


      Group DateAmountIDGroup ID




      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!