1 2 Previous Next 19 Replies Latest reply on Nov 5, 2013 10:31 AM by Matt Lutton

    aggregate multiple sources

    Julianna Wokurka

      I have two sources.

      One with order information, item number, number of items sold

      The other with item number, item size (cubic feet per item)

       

      I need to determine how much actual cubic feet are moved each day.

      I need to make a calculated field that does a row calculation:

       

      Quantity Sold (Qty) * Item Cubic Feet (CF)

       

      But Qty and CF are from two different sources and I can't figure out how to get these together.

       

      Please help if you can, I really appreciate it.

        1 2 Previous Next