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

    Lookup and multiply from another data source




      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.