Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Anyone able to tell me how to highlight the duplicates in Row 56 and 57
and also in Row 75 and 76?
Thx in advance
EDIT: I scrambled the GS Number field, so the rows might change!
Try this
=Aggr(NODISTINCT If(Count({$<WeekDiff={'>$(vZeitraum5KW)<=$(vZeitraum4KW)'}>} GS_Nummer) > 1, LightGray()), GS_Nummer)
I am not sure why do you consider them with having duplicates... when I select Row 79's GS_Nummer (IB4989691)... I see only 1 row. Same is true when I select Row 80's GS_Nummer
hi sunny,
was my mistake.
please look at this pic:
Okay those make sense, but they are not 79 & 80 or 150 & 151 which is what confused me. Going back to your question, what would you like to highlight? Dimension or expression or both?
Try this
=Aggr(NODISTINCT If(Count({$<WeekDiff={'>$(vZeitraum5KW)<=$(vZeitraum4KW)'}>} GS_Nummer) > 1, LightGray()), GS_Nummer)
Hi Sunny,
I am looking to find duplication based on 2 dimensions.
I have assigned an invoice item line number to each invoice no and need to be sure that there is no duplication. of those 2 values.
i tried like this in a text box
='Number of Duplicates = ' & Sum(Aggr(If(Count([Invoice no.])>1,1,0),[Invoice item line number]))
but this returns some duplication, when i check those Invoice no. each line has a unique Invoice item line number
Can you share how to check if duplicates exist using 2 dimensions as the unique value?
Thanks
Daniel
May be you need to check Distinct Count
Sum(Aggr(If(Count(DISTINCT [Invoice no.]) > 1, 1, 0), [Invoice item line number]))
Many thanks for the reply,
when i add that, the expression just appears in the box,
i did add Distinct to my example:
='Number of Duplicates = ' & Sum(Aggr(If(Count(DISTINCT[Invoice no.])>1,1,0),[Invoice item line number]))
but the return is the same.
Can you confirm the above is checking duplication using 2 dimensions as a unique key?
Thank you Sunny