4 Replies Latest reply: Jul 16, 2015 10:26 AM by Phaneendra Kunche RSS

    Join tables but not duplicate data..

    Neil Deeley

      Hi,

       

      Apologies if the title of this question doesn't make sense - I don't know how to describe it!

       

      I have two tables. Table A shows a list of sites, a Month, and a budget for that month:

       

      A.SiteA.MonthA.Budget
      My PlaceJan1000
      My PlaceFeb2000
      My SiteJan1000

       

      The budget shows the total sum that site is allowed to spend.

       

      I need to join this in Sense to Table B, which shows what actually has been spent, by item:

       

      JanJan40.00
      B.SiteB.MonthB.ItemB.Amount
      My PlaceGloves30.00
      My SiteShoes

       

      I've tried joining the two tables using every join method I can think of, but when I do the Budget column is duplicated, and therefore the total sum of that budget is incorrect in the app:

       

      A.SiteA.MonthB.ItemB.AmountA.Budget
      My PlaceJanGloves301000
      My PlaceJanShoes401000
      My PlaceJanGloves201000
      TOTAL903000

       

       

      How do I join the tables so that the Amount is Totalled by the Budget is shown only once?

       

      Hope that makes Sense!