4 Replies Latest reply: Oct 22, 2014 9:47 PM by Miltos Karlos RSS

    Calculate Cost per Unit - Split String?

      Hello,

      I am using the Northwind Database (Microsoft) as an example and i am facing the following issue:

      I want to calculate the Profit Margin. I do have the Sale Price per Unit. When it comes to the Cost per Unit,

      the amount is for a whole box. To make it more clear i ll give an example:

       

      Sales in Retail

      Product                    Quantity              Price

      Coca Cola Can              1                  $1.55

       

      Procurement (wholesale from the distributor)

      Product                                      Quantity                  Price

      24 cans Coca Cola (box)                 1                        $22.00

       

      There is inconsistency between buying from the wholesaler and selling retail.

      In other words, I would like to distinguish somehow the number of products in the box(24) and then use it

      to find the Cost per Can.

       

      Please help!!!! Thank you