Report to count occurrences of subst characters in a subject line
SummaryReport to count occurrences of a subst of characters in a subject line which vary depending on customer requirement
Hi all. I'm not sure if this can be done but I am needing a report that counts the number of occurrences of 8 characters in a subject line. These 8 characters vary depending on the customer requirement. I can see the count I want in a rollup of the report, but I'm unable to generate a similar count in a cross-tab report.
Important note: The subject line column (Code) in the standard grid report is an expression to isolate only the required characters, ie: "ltrim(subst(incidents.subject,49,8))"