3 Replies Latest reply on Aug 17, 2018 9:28 AM by Maxanne Durkee

    Blending two data sets on multiple fields

    Maxanne Durkee

      I need to blend two data sets (one with franchise sales data and the other with expense data)

      I need to blend on three fields in order to avoid duplicates errors. Then I need to sum for a final field

      The expense file will have:

      Branch ID

      Lead Category

      Month Year

      Expense amount

       

      The sales file has the first three fields so I want to blend on all three in order to arrive at the expense amount to sum. When I attempt this I am getting strange sums. I have isolated a single month/year and a single branch and a single lead category but the qty is incorrect.

       

      Any ideas if I can improve the blending method?

       

      Thanks for any help,

       

      Maxanne