I trying to get how long it takes our warehouse to ship orders. I have the following expressions that work from an individual order perspective
NetWorkDays(CalendarAvailableShipDate,CalendarShipDate)-1 = Calculates the days is takes to ship
if(Column(2) >= 8,1,0) = Takes the above expression and let's me know if order take longer than 8 days then puts a 1
The above works for each order, but when I want to see it based on a Customer perspective, it falls apart.
How can I write the above so when I group the pivot table by customer it will then add up all the orders and then divide by how many were late (if(Column(2) >= 8,1,0))
I assume you calculate these expressions on the front end.
Each order has one ship date but each Customer has multiple, hence it "falls apart". You can make it much easier by calculating the days and the late flag in the script.
