Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how does one check for duplicate entries in a field , and identify maximum value with duplicate entries?
May be create a straight table like this
Dimension
FieldName
Expression
Count(FieldName)
Or in a textbox:
=Max(Aggr(Count(FieldName), FieldName))
show that field in listbox and check frequency option and also select frequency option under sort tab of list box properties(ascending/descending).it shows the count of repetitions of the field records.
Hi,
Another way via front,