COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ccbarbeau on 17 Jun 2011 09:45:51 AM

Title: Distinct function
Post by: ccbarbeau on 17 Jun 2011 09:45:51 AM
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