BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Trying to eliminate rows were certain fields are null


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
vikingtheblu
Forum Member
Forum Member



Joined: 29 Nov 2019

Posts: 1



PostPosted: Fri Nov 29, 2019 1:45 pm 
Post subject: Trying to eliminate rows were certain fields are null

Org Name, Org Outcome, Individual Name, Individual Type, Individual Outcome

I have the above fields in a report I am trying to create.

There is always only one org name.
There can be one or more individual names for an org.
The org can have no outcome or have an outcome.
Each individual can have no outcome or have an outcome.

I get the following:

Org Name -> Org Outcome -> Individual Name -> Individual Type -> Individual Outcome

A -> Fined -> Bob -> Primary 1 -> Null
A -> Fined -> Bill -> Primary 2 -> Null
A -> Fined -> Jane -> Primary 3 -> Null

The org is the same but the org has 3 different individuals.
The org has an outcome but none of the individuals do.

I do not want the report to show the 3 lines.

If Individual Type = Primary 2 or 3 and the Individual Outcome for each is null, then I do not want those rows to show.

Since Primary 2 is null, I want to hide that row.

Since Primary 3 is null, I want to hide that row.

Please help for the best way to do this.

Thanks.
Back to top
n8aktiv
Principal Member
Principal Member



Joined: 28 Dec 2018

Posts: 127


flag
PostPosted: Sat Nov 30, 2019 6:32 pm 
Post subject: Re: Trying to eliminate rows were certain fields are null

create a variable with all the if-combinations.
set the result to '1' if you want to show the line and '0' if you want to hide.

filter your output/table to 'variable = 1'

_________________
------------------------------------------
SAP BO 4.2 SP6 Patch 10
------------------------------------------
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 18 queries. (SQL 0.0027 Parse 0.0008 Other 0.0233)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo