Can I Share a value returned from a report function?

Question

I have two report functions:1. counts all the occurrences of courses that match a specific school year.2. gives me a total count of coursesI also need to count the occurrences of  courses that do not match a specific school year. How can I subtract the value from the first report from the second report function?Is there a better way to do this?

EddieLotter · Accepted Answer

As always, try to do as much as you can on the database side.

For example, in Microsoft SQL Server you could do the following:

SELECT

schoolID, courseID, additionalFields,

CASE WHEN CourseYear = SchoolYear THEN 1 ELSE 0 END AS CourseYearMatch,

CASE WHEN CourseYear <> SchoolYear THEN 1 ELSE 0 END AS CourseYearMismatch

FROM tableName

Then, in Report Builder, you can use simple calculated fields to sum these two fields to get the counts you want.

Cheers

Eddie

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.