Hi All,
I know the question has been asked before, but I cant get it to work. I have two tables with a many to many relationship. Its delivery data for warehouses, and there are "expected" delivery dates and "actual delivery dates.
The "actual delivery" dates are captured in a table named "101_data". The "expected delivery" days are residing in a table named "PO_Data".
My objective is to determine whether a supplier delivers before or after the "expected delivery" dates. So the result of the calculation would be any negative value would indicate the amount of days delivered early. Positive values would indicate the amount of days delivered late.
I have run a pilot in excel where I substract the two dates from eachother which poduces the desired result.
What would the calculation look like as the two colums resides in different tables as indicated above.
Thanks, Jan
