You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Highlight Duplicate String Values

in Reporting and Analytics for ERP 1 comment

Summary:


Content (please ensure you mask any confidential information): In an OTBI analysis, I would like to highlight duplicate string values. Is this possible?

We're using the Subject Area Fixed Assets - Asset Transactions Real Time and we want to highlight duplicates on the "Fixed Assets - Asset Transactions Real Time"."Descriptive Details"."Serial Number" column

Neither SUM(1 BY or SUM(COUNT GROUP BY has worked for the column formula to highlight duplicates


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT   "Fixed Assets - Asset Transactions Real Time"."- General Information"."Book Code" s_1,   "Fixed Assets - Asset Transactions Real Time"."Asset Category"."Segment1" s_2,   "Fixed Assets - Asset Transactions Real Time"."Asset Category"."Segment2" s_3,   "Fixed Assets - Asset Transactions Real Time"."Descriptive Details"."Serial Number" s_4,   "Fixed Assets - Asset Transactions Real Time"."General Information"."Asset Number" s_5FROM "Fixed Assets - Asset Transactions Real Time"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!