2 Replies Latest reply on Jun 12, 2018 4:55 PM by Deepak Rai

    Adding Item Cost and Shipping Cost for Total Price Custom Calc

    Ronald McPherson

      Hi All,

       

      I'm a bit stumped here and I've even revisited my lessons on the Superstore data set but still can't seem to figure this one out, or more specifically what I am doing wrong!

       

      I have the following data (subset):

            

      Item NumberOrder TimeItem CostShipment DateShipping CostOrder Status
      ar1eLY5suhYasdsasad3/22/2018193.2674213/22/20183.856999processed
      jIrqzP_B1pgdfae3/6/2018155.9261293/6/20189.143673processed
      Z4wIWtPUaZMxzcz4/6/2018154.1654424/6/20184.542121processed
      l9RA-42EAr8sadh4/6/2018147.3421644/6/20185.281353processed
      ZEjBHM1HPNolkg2/22/2018134.0896042/24/20182.389817processed
      P2zv4yNIXb8ghlk1/30/2018116.6056841/30/20187.189588processed
      ar1eLY5suhYasdsasad3/28/2018123.093313/28/20182.2381processed

       

      I am trying to create a calculated field which sums the item and shipping cost.  I keep getting all sorts of odd results.  I believe part of the complication is that the Item Number is repeated throughout my data set and is tied to different dates.  For example, item number 'ar1eLY5suhYasdsasad' was ordered on 3/22 and on 3/28 and both costs were different in these cases.

       

      Thanks for taking a look and appreciate any guidance/solutions that anyone can provide!