Hello everyone,
I am struggling with some issue.
I have a table with dates of PURCHASE ORDER, REQUESTED DATE and DELIVERY TIME.
I built:
- Requested delivery time
- Real delivery time
- Real vs Requested
- Column = 1
NEXT STEPS :
I want to create three more columns which is:
- sum( Real vs Requested ) , but this does not work, if I sum a master item (ONLY THE VALUES HAS BEEN MORE THAN 3 DAYS LATE)
- Sum ( colunm 1) , this trigger on counting all the values we need to analyze (TOTAL)
- DELAY : sum( Real vs Requested ) / sum(colunm 1) , is the aim of this calculation, percetage of delays, against total.