Hi there,

I'm trying to get a sum of a field where a different field is distinct. Here's an example of my report:


EID     Name     FTE     Leave     Balance
100001     TEST     1.00     Annual     100
100001     TEST     1.00     LSLeav     50
100002     TAXT     0.75     Annual     200
100002     TAXT     0.75     LSLeav     10
100003     SMIT     1.00     AltDay     2
100003     SMIT     1.00     Annual     85
100003     SMIT     1.00     LSLeav     15


I'm trying to sum the FTE column but I only want it to use the figures for each individual employee (so it should sum 1.00 + 0.75 + 1.00). Any thoughts on how to make this work?

I'm using Crystal Reports XI if that helps :)

Cheers,
MJ