Hi there!
I am just trying to consolidate to tables ("sales header" and "sales header archive") to one data source using NP("Union"). My goal is to generate a list of all debtors with whom we made sales contracts in a specified date range (and process several further calculations with this list). My formula looks like:=NL("Zeilen"; NP("Union"; NL("Filter";"Verkaufskopfarchiv";"Verk. an Deb.-Nr."; "Buchungsdatum"; PeriodeFilter&"|"&VorpoeriodeFilter; "Verk. an Deb.-Nr.";DebitorFilter); NL("Filter";"Verkaufskopf";"Verk. an Deb.-Nr."; "Buchungsdatum"; PeriodeFilter&"|"&VorpoeriodeFilter; "Verk. an Deb.-Nr.";DebitorFilter)))
where PeriodeFilter and VorperiodeFilter specify a date range and DebitorFilter filters a Debtor (-range) or is equal to "*".
Unfortunately the formula returns an error message like "This formula is too long or too cascaded to work" (or similar).
Where is my fault?
Thanks a lot in advance!
Frank
Date
Votes
2 comments
-
Jet Reports Historic Posts OK, obviously it is more "digestible" for JetReports when separating both NL("Filter") into single cells and refer to them within the NP("Union") call.
By now it works using this work around … -
Jet Reports Historic Posts There is a limit on formula length, it has been discussed here in some topics.
Splitting the formula where possible is the best and only solution iirc…
Please sign in to leave a comment.