I have a subreport that is passing a number to the main report for each sample. (In the red box below)
Now I want to create 2 formulas in my main report in my footer to do:
1. Tells me the number of samples with a value >10
2. A percentage of samples with less than 10.
How do I do this and is it possible to evaluate shared variable values?
Subreport formula:
WhilePrintingRecords;
Shared numbervar Turnaround:={@TurnaroundTi
me}
Main report formula:
Shared numbervar Turnaround;
Turnaround
Change the sub report formula to gather the information
Add a formula to the main report to declare the shared variables
Name - DeclareVariables
Location - main report header
Open in new window
Change the subreport formula
Open in new window
In the report footer add 2 formulas
Name - NumGT10
Open in new window
Name - Less10Percent
Open in new window
mlmcc