Counter for unique values

[former_member206475]

Hi Guys,

Need suggestion on the below situation..

I have a Characteristic..

Field1

100

200

300

400

100

100

Now i have to populate a count of the unique values for this field in BEx functionality.

So another field to be created which will show the result in report for above data as 4.

It should just take count of 1 even if there are duplicates whether 100 or any other value  is shown as many times in data.

Please suggest how to achieve this.

Regards

Zabi

[former_member183012 · Accepted solution]

Hi Syeb,

I think you should achieve this using Exception and aggregation in query designer.

Cerate formula put 1 in that using counter or summation ith referance charecteristic you can solve your problem.

Please try this.

Regards,

Ganesh Bothe

[former_member206475 · Accepted solution]

Hi Ganesh,

I dont want the duplicates values to be counted more than once. only one unique value should be counted.

In a dataset i can have many records with same values but it should take only one count as unique value..

[former_member183012 · Accepted solution]

Have you tried above thing in your query?if not please try once not sure but reference charecteristic will check distinct records..I remembed In HR reporting i used for counting number of records.please try this.

Regards,

Ganesh Bothe

[sriramvijay_ravidoss · Accepted solution]

Hi,

Drag and drop your characteristic in rows and create a formula with =1 in rows this will satisfy your requirement.

If you  want it to be done in some other layout, Please share your layout to discuss further.

-Sriram

[RafkeMagic · Accepted solution]

the suggestion by Ganesh Bothewill not have duplicates... at least not if you select the reference characteristic correctly