Hi guys, i have a problem with a report
Let me explain a bit, I have information from 2 universes:
Universe 1: Number Obl, Date Ing
Universe 2: Number Obl, Date Ges
I make a merge in Number Obl an make a detail variable in Date Ges (Image 1), I obtain #MULTIVALUE error, and this makes perfect sense because there is a 1:N relationship between Number Obl and Date Ges, then y click on “Avoid duplicate row aggregation” (Image 2) and works fine, but i got repeat rows, for that i create a variable (Concatenate) for every row and create a new variable with this for filter:
(= If [Concat] = Previous([Concat]) Then 0 Else 1) where 1 is non repeat row and 0 repeat row, then i try to filter the new variable for 1 but don’t works, it still give me 0 and 1 rows (Image 3).
How i can filter this, i need select “Avoid duplicate row aggregation” and i can’t make a MAX or MIN function because lost many dates (Date Ges), thanks.
Jeanpablo14 (BOB member since 2020-02-26)