Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get distinct count when there are duplicate records.

  I have an issue and require expertise advice as I am new to SAP Crystal reporting.

  1. I am generating report on total number of Incidents
    resolved by different ITSM tools.
  2. There are two tools IT-Assist and QMS.
  3. And the Boolean which helps me to filter data is
    column 3 ByITAs.
  4. If column 3 is 0 then resolved by QMS else
    IT-Assist.
  5. Now the issue is we have reopened Incidents on
    the list coming.
  6. As you can see Incident 181 is reflecting
    multiple times this is effecting my total count.

             

I used a section suppress and suppressed the ID column to
show only distinct records but there is no alterations in count.

How can I get exact count now, kindly help?

Tags:
Former Member
replied

Hi Rizwan,

Try this please:

1) Right-click 'Running Total fields' from the Field Explorer > Choose the Incident ID as the 'Field to Summarize' > Choose 'Distinct Count' as the Summary Type > Name this "QMS"

2) Under Evaluate, choose 'Use a formula' and use this code:

{Column3} = 0

3) Under 'Reset' Select Never

4) Create another Running Total field > Name this 'IT' > and use this Evaluate Formula:

{Column3} <> 0


5) Drag and drop both the Running Totals on the Footer and place them beside their respective labels.


-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question