SAP - Web Intelligence - Duplicate Rows

[Former Member]

Hi,

I've tried to search but I'm not even sure where to begin. I have just started learning this tool and I'm unsure what to do.

When I generate a report, I get the one below:

I need this to display the incident identifier only once. However, the duplicate option will not work because the Created field is unique. I need the result to be:

8015     06-01-2015

74700   06-17-2015

3771     06-20-2015

6128     06-21-2015

I'm also not adept with SQL.

[Former Member · Accepted solution]

If that's all your table is and the objects are the same name as your headings then change =[Created] to =Min([Created]) and change =[Days Open] to =Max([Days Open])

[Former Member · Accepted solution]

@mark: Let me give this a try.

[Former Member · Accepted solution]

@mark: Thanks. I guess it worked!!!

[Former Member · Accepted solution]

Thought it might. It's worked since I started working with BusinessObjects in 1996.

[vijaymuniraj]

Hi,

Days open field has two records for each incident identifier. How you wanted to display? only the first record?

[Former Member]

Attaching screenshot as advised.

I want to display the the incident number (should only be 1 instance) with the oldest CREATED date. Days open is a formula based on Now-created..

[amitrathi239]

attach the screenshot.

Amit