3 Replies Latest reply on Jul 11, 2018 2:54 PM by Shinichiro Murakami

    Lookup and multiply from another data source

    tarang.patel.3

      Hello!

       

      I am struggling looking up and multiplying across data sources. I want to multiply the units from the first image by the cost of the product in the second image multiplied by the customer multiplier on the third image. For example: 1 Apple unit * 5 (cost of an apple) *0.5 (for customer A).

       

      At the end I want a summary for the cost for customer A and B.