Distinct function

[ccbarbeau]

All,

I have a requirement where I must calculate the % completed on a task by checking how many detail lines have a quantity complete vs quantity ordered of 100%. That part is ok.

My issue is that I am working with product line/number, and that the same line/part number can show up several times on the same task. RS 8.4 is totalling the quantities, which is expected. I could set the Auto-group and summarize to NO, but then all my data items with a total(distinct) or a count(distinct) no longer function properly.

I am using RS 8.4 off of a DB2 database.

Any ideas?

Thanks,

CC