Hey guys,
I'm having what I think might be a simple-fix issue (I hope).
Basically I am have a series of Discrepancy pages grouped by Discrepancy #. Each row within that Discrepancy # has Discrepancy Type and Corrective Action Descriptions.
Rows output as:
Discrepancy# - Discrepancy Type - Corrective Action Description
1 - 12 - Issue found
1 - 12 - Issue worked on
1 - 12 - Issue corrected
2 - 56 - Issue found
2 - 56 - Issue worked on
2 - 56 - Issue corrected
I want to get a count of the Discrepancy Types, but because it's repeated in every row I am getting a higher count than what's actually there.
How would I go about only pulling the Discrepancy Type once per grouping(Discrepancy #)?
Thanks!
Quote from: cognosehelp01 on 10 Nov 2014 10:27:47 AM
Hey guys,
I'm having what I think might be a simple-fix issue (I hope).
Basically I am have a series of Discrepancy pages grouped by Discrepancy #. Each row within that Discrepancy # has Discrepancy Type and Corrective Action Descriptions.
Rows output as:
Discrepancy# - Discrepancy Type - Corrective Action Description
1 - 12 - Issue found
1 - 12 - Issue worked on
1 - 12 - Issue corrected
2 - 56 - Issue found
2 - 56 - Issue worked on
2 - 56 - Issue corrected
I want to get a count of the Discrepancy Types, but because it's repeated in every row I am getting a higher count than what's actually there.
How would I go about only pulling the Discrepancy Type once per grouping(Discrepancy #)?
Thanks!
This is a duplicate post. Please read Forum Etiquette page.
http://www.cognoise.com/index.php/topic,26421.0.html