Hi,
I would like to calculate a percentage for delivery performance.
In CH704 calculations are done for Planned orders (Gepland) and Delayed orders (Te laat >0uur).
Distinct is used, because orders are planned multiple times on a day, but I only want to count them once.
The totals on top of the table are set by Total mode 'Sum of Rows'. (when I set the Total mode to 'Expression totals' it returns 1)
Object CH612 should show the delivery performance.
In this case it should be 1-29/84 = 65,5%
Just copying the formula for 'Gepland' and 'Te laat >0uur' in above formula results in 50,2%, which is wrong.
I think the problem has something to do with using Distinct and Sum of Rows.
The formulas are a bit complicated, but I hope anyone can help me to find the right way to do this.
Thanks in advance!