3 Replies Latest reply on Jan 26, 2019 12:34 AM by Prasanna R

    Unable to join or blend

    kaiboon.ong.0

      Hi,

      I was unable to join both sales and delivery order together because there is no unique field so i used data blend and i used the calculation below to find out the on time delivery. I have encountered a problem of getting 0 and null value. How do i solve it ? Are there any possible ways other than join and blend that i can combine my data together?

      DATEDIFF('day', MIN([Delivery Date]) ,ATTR ([DOR cleansed finalised (1).[Delivery Date])