We calculated 6 different lead times. Each lead time is specific for a certain role. Each of this calculation has several Case when formulas in it. These 6 lead times are saved in KPI.
Now I would like to calculate AVG of all these lead times. The problem starts here. I actually can not get the correct values.
Does someone have a working solution for this situation ?