Hello Everyone
I’m relatively new to Business Objects Webi reports and was wondering if someone could help me with the correct syntax on counting Duplicate and unique values. The data below
ID ID2 y/n Type
111185531 TE14795 YES LETTER
112082110 ID06948 YES LETTER
112082110 ID08882 YES E-MAIL
132124835 ID05558 YES FAX
I’m trying to get the following outcome.
Duplicate count = 1
Unique counts = 2
I have tried the following code and it either does not work or gives me the wrong numbers.
Count([ID] In ([ID]))
=Count([ID];Distinct)
=If([ID]>1;“Duplicate”;“Unique”)
Any type of help would be appreciated.
Thank you
Ramatulai (BOB member since 2015-12-01)