I am attempting to count all of the entries which are overdue for a given period, that is the actual completed date is after the expected completed date. I am trying to use a calculated field but it is returning an error that ="">""&NF(,""ExpResDate"") is not a valid filter.
Here is the NL statement:
=NL("Count","CustComplaint",,"ActResDate",*daterange*,"ActResDate","="">""&NF(,""ExpResDate"")","ActResDate",$D8)
Any help would be greatly appreciated.
Thanks.
Date
Votes
2 comments
-
Jet Reports Historic Posts Calculated fields are only valid for NAV data sources. I'm guessing from the name of your table that you are using a universal data source, which do not support calculated fields, filters, etc. In order to achieve this with a Universal connector, you would want to use SQL= and create a custom SQL query.
Regards,
Hughes -
Jet Reports Historic Posts Oh alright, thank you!
Please sign in to leave a comment.