Hi all,

I've created a report showing the different collections per client. These collections are then devided into 2 colloms, Paid to us, and paid directly towards the client. Now I would like to give a percentage of the amount paid to us, and the amount paid to the client.

I want it to look like this:

Client      Collections   To us   %us   % To client    %client
Client A   100E           75E       75%        25E            25%
Client B   200E           75E       37,5%    125E        62.5%

Total      300E          150E          50%     150E        50%

Can anybody help me with this?

Thanks in advance

Gerben

I thought exactly the same, however, I'm getting or 1, of 0. Does is matter that the collections are a sum? I grouped the clients, and placed a sum over the collections...

I'm still getting 0 or 100 out of it. It looks like it is only looking at the first payment of the group, instead of the combined paymenst.

Works perfect, thanks!