I have a variable in the heading of my report that gives you a count of the rows returned {prescriptions} in the report by Third Party Agency. The report for example has 8 rows {prescriptions}. When I filter the report for only 3 rows, the count still represents the number of rows returned as 8 and not the 3 rows in the report. How can I manipulate the calculation to only represent the 3 rows in the report?
Calculation: =Count() The count of Prescriptions returned in the query
I have tried the following with no success:
The following just gives me count of 8
=Count() In Body
=Count() In Report
=Count() In Block
The following just gives me count of 1
=Count() In Report ForEach =Count() ForEach In Report =Count() ForEach In Body =Count() ForEach In Block
I know it is probably a simple solution, but I just can’t nail it.
Any suggestions?
Gail McGuire
Applications Analyst
<<…>> CVS Corporation
Pharmacy Data Warehouse
401-765-1500 x2236 gbmcguire@CVS.com
Try this:
Go to the menu bar… Format/Filters
Drag your {prescriptions} filter from the block folder (e.g. “Table 1”) to the “Global” folder. Global filters affect all the sections, blocks and calculations in the report, and so your heading variable should work without modifications.
Cheers,
Luis Gonzalez
From: McGuire, Gail B. [SMTP:GBMcGuire@CVS.COM]
I have a variable in the heading of my report that gives you a count of the
rows returned {prescriptions} in the report by Third Party Agency. The report for example has 8 rows {prescriptions}. When I filter the report for
only 3 rows, the count still represents the number of rows returned as 8 and
not the 3 rows in the report. How can I manipulate the calculation to only
represent the 3 rows in the report?
It may depend on WHERE you have your filter applied. If you have the filter applied at the Table Level, it will not affect the GLOBAL count.
Try moving the Filter to the GLOBAL level and then check the count…
Also… if you are trying to get a count of the distinct number of values, you may want to use a count of a count… (recursive count). i.e.: =count(count())
In a message dated 11/13/98 8:54:29 AM Eastern Standard Time, GBMcGuire@CVS.COM writes:
<< I have a variable in the heading of my report that gives you a count of the
rows returned {prescriptions} in the report by Third Party Agency. The report for example has 8 rows {prescriptions}. When I filter the report for only 3 rows, the count still represents the number of rows returned as 8 and not the 3 rows in the report. How can I manipulate the calculation to only represent the 3 rows in the report? >>
Try looking on website; there is a document there that discusses how to count with or without filters in a report.
Start at www.islink.com/bobjtech.htm and look for the document that talks about filters! It should provide options that do what you need.