7 Replies Latest reply on Jul 17, 2018 4:51 PM by Deepak Rai

    Multiplying data by a list of values

    tarang.patel.3

      Hi,

       

      I'm trying to multiple data by a list of  values. Units are multiplied by cost/unit and discount multiple. Please see Excel file for first two tables.

       

      This is how my data looks.

       

        

      Customer# of units
      A 42,342
      B 4,234
      D 10,003
      E 647,567
      F 42,342

       

      This is the list.

        

      Cost/unit Discount multiple
      $ 1.00 $                      0.25
      $ 1.00 $                      0.50
      $ 1.00 $                      0.75
      $ 1.00 $                      1.00
      $ 1.50 $                      0.25
      $ 1.50 $                      0.50
      $ 1.50 $                      0.75
      $ 1.50 $                      1.00
      $ 2.00 $                      0.25
      $ 2.00 $                      0.50
      $ 2.00 $                      0.75
      $ 2.00 $                      1.00

       

       

      This is the end products I would like.

       

          

      Cost/unitDiscount multipleCustomer Cost
      10.25A $      10,586
      10.5A $      21,171
      10.75A $      31,757
      11A $      42,342
      1.50.25A $      15,878
      1.50.5A $      31,757
      1.50.75A $      47,635
      1.51A $      63,513
      20.25A $      21,171
      20.5A $      42,342
      20.75A $      63,513
      21A $      84,684
      10.25B $        1,059
      10.5B $        2,117
      10.75B $        3,176
      11B $        4,234
      1.50.25B $        1,588
      1.50.5B $        3,176
      1.50.75B $        4,763
      1.51B $        6,351
      20.25B $        2,117
      20.5B $        4,234
      20.75B $        6,351
      21B $        8,468