I want to create a report to overview our contactpersons per customer. My problem is that jet keeps copying the names and i cant seem to figure out why. When there are four contact persons, I only want to see those four and then on to the next customer.
I attached a file as example. Could someone tell me what I am doing wrong. ( as I have the Ducht version, my functions are mentioned in Dutch. )
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment it's the "rijen" in "rijen" in "rijen" that kills it
=NL("Rijen";"Relatie";;"Nr.";13150)
is ok, but then you do
=NL("Rijen";"Contactpersonen";"Titel";"Relatienr.";$E6)
=NL("Rijen";"Contactpersonen";"Voornamen";"Relatienr.";$E6)
…
Which should be
I6 =NL("Rijen";"Contactpersonen";;"Relatienr.";$E6)
=NF(I6;"Titel")
=NF(I6;"Voornaam")
Hide column "I" and you should be ok. -
Jet Reports Historic Posts Thanks Jan, this works perfectly. I assumed the NF wouldnt work on the second NL, but thanks for your help.
Please sign in to leave a comment.