Share Values from a Sub Report

[former_member424792]

Is there a wan to share the Values from a sub-report? I am creating a report that shows error counts. However I am having to exclude some values and when I join another table to the view with the exclusions  my numbers get thrown out of whack, and I understand why that is. So I am looking for a work around. I need to show the total number of "replacements", which I have this. I need to show the total number of files complete, which I have in a sub-report. The problem I am having is I need to show a "error percentage" Taking the total number of errors divided by the total complete. Is there a way to share the values from either sub-report so that I can calculate the percentage?

I hope I am clearly stating what I need help with.

[abhilash_kumar]

Hi Matt,

Use a shared variable to store the total number of errors and another shared variable to store the total number of files complete.

You can then create a new formula in the Main Report (or wherever you wish to display the %) with this code:

shared numbervar complete;

shared numbervar errors;

If complete = 0 then 0 else

errors % complete;

-Abhilash