troubleshooting Question

Cognos Report Studio Zero suppression

Avatar of pashi_26
pashi_26 asked on
DB Reporting Tools
2 Comments1 Solution1700 ViewsLast Modified:
We migrated few reports from 7 to 8. After migrating everything looks fine except one issue.
Report is having 3 prompts i.e,  month start date, month end date and sales begin date for that year. (which is 3/1/07, 3/31/07, 1/1/07 as an example). At the end of the report we need to summarize the sales like 1) Total sales (which is total month sales) 2) Total YTD sales ( which is the total year to date sales for that year)
In  that report one column (Total sales for particular month) is having $0 valued Rows, where they are no sales. We don't want to show them in the report, so we used 'Total sales <>0' filter to filter out the zero value rows.
Here comes the problem.
If we don't use the filter report doesn't have any issues. But, if we use the filter: Total sales and Total YTD sales is giving the same number, which is wrong. Total YTD will be always greater than Total sales.

I'm having the problem with the filter so, I thought of using ZERO SUPPRESSION which is one of the option we can use in Report studio. But, its not suppressing the zero values.

FYI: it is a list report and still the same report runs without any errors in version 7.

How to use the Zero suppression in Report studio?
Any help is really appreciated as I need to solve this issue asap.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros