Percentage of sum of rows

[#1]

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!