in

 

Zero suppression

Last post 09-05-2008 7:01 AM by christulino. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-30-2008 5:25 PM

    Zero suppression

    It seems that ARB has a default feature that automatically suppresses zero or null values. I would like to disable this feature but can't seem to find the solution on my own. What I need is for a list or crosstab report to show me all member names, regardless of whether their allocation hours are 1000 or zero. Right now my reports omit any members that have zero allocation hours. Can somebody please help?

     Thanks!

    Filed under:
  • 09-05-2008 7:01 AM In reply to

    Re: Zero suppression

    You should create a query that lists the member names, and then use an outer join (1 to zero or many) to link the member name to the data you are viewing (even if it also contains member name).  Then your result set will contain all members.

    If you want null values in a report to show zero, try the coalesce funtion.  It returns the first non-null argument, so if you change [Relational View].[Allocations].[Allocation Hours] to coalesce([Relational View].[Allocations].[Allocation Hours],0) you will either get the value of allocation hours, or a zero.  That combined with the join should get you what you want.

     

     

Page 1 of 1 (2 items)

Navigate: Home | Blogs | Forums | Solution Library  Get Help:  Contact | Feedback | FAQ   Terms of Use:  Terms & Conditions | Privacy Policy