Reports - Case Count Column

You may want a column that displays a 1 for each case in a report. For example, to give a Summation something to count.

Click on Advanced Add Columns, then in the Method 2 section, add a "New Literal Number" column to the report. If you are counting cases, add the new column from the Case Data fields list:

Then edit that column after it appears on your report. Optionally change the Heading. Put the number 1 in the Expression box:

Now  your report will show a "1" in that column on every row.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us