Pl. check the attached report and clear the error.testing.xls
Date
Votes
4 comments
-
Jet Reports Historic Posts You formula is too long. The max length is 255 characters. You could change the NL("AllUniques") to NL("Filters") and move them to cells of there own.
-
Jet Reports Historic Posts tried changing "AllUnique" to "Filter" then also I received the same error. Moving to their own cells is not understood, could you pl. expand the wording to understand better. If possible pl. shown changing the code in the attached .xls file.
-
Jet Reports Historic Posts hnetscape,
can you post a copy of the report so we can take a look at it. -
Jet Reports Historic Posts The error seems to be in D7, so I would start with that. Things to try:
1) Break it down into seperate smaller formulas, put the Allunique as Filter and have it in a seperate cell.
2) Remove all of the arguments, ensure the formula returns something non-error. Then gradually re-add until you find an error.
3) You may be over the size limit. Try replacing table names with their object ID to get some space.
4) Try using Filter instead of Link= (just to see).
Basically, make the formula as simple as possible, and work up from there.
Please sign in to leave a comment.