We help IT Professionals succeed at work.

Suppress duplicate values

Gordon Hughes
on
I would like to supress a dulicated value against a record, not against the next record
If i use the option to Suppress if Duplicated in the format editor it supresses duplicated vales against any following record
Guess I need some formula, but don't know what this should be

See attached doc picture
Gordon
Suppress-Duplicates.doc
Comment
Watch Question

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
So you want to suppress duplicate values in the next record if it is in the same group.

Group 1
   Joe       15    some text
                15   some other text  --- you want to suppress the 15

Group 2
   Pete     115   some new text

Group 3
   Tom     115   other text              --- you want to see the 115


I think you can conditionally suppress  duplicates using
    NotOnFirstRecord AND (Previous(GroupField}) = {GroupField})

mlmcc
mlmcc
Gordon HughesDirector

Author

Commented:
Hi mimcc

Do I insert the group name into the formula where your quote group name?

Gordon
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Use the group field so if you are grouping on Table.Name it is

NotOnFirstRecord AND (Previous(Table.Name}) = {Table.Name})

mlmcc

Gordon HughesDirector

Author

Commented:
Hi mimcc
Tried your suggestion, but I am probably putting the wrong information in the (Table,Name)
Have attached the word document with the design view show, can you help from here
I am trying to apply the format editor to this field

Gordon
Suppress-Duplicates.doc
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
NotOnFirstRecord AND (Previous({W0.W0Type}) = {W0.W0Type})

mlmcc

Gordon HughesDirector

Author

Commented:
Hi mimcc

I think I  must be missing something
I am using the format editor for the field WOEQLIST.DOWNTIME on the commontabl select the suppress if duplicated and selecting the exception button, pasting your suggestion NotOnFirstRecord AND (Previous({W0.W0Type}) = {W0.W0Type}) and when I check it says the remaining text does not appear to be part of the formula, when I select Ok it puts the cursor at the front before the Not

Gordon
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Sorry, there needs to ba a SPACE after NOT

Not   OnFirstRecord AND (Previous({W0.W0Type}) = {W0.W0Type})

mlmcc
Gordon HughesDirector

Author

Commented:
Hi mimmcc

Excellent stuff I just need to change it to
Not   OnFirstRecord AND (Previous({W0.W0Type}) = {W0.W0Type})

Works fine
Thanks for your help
Gordon
Gordon HughesDirector

Author

Commented:
mimcc, Excellent as normal