Skip to Content
0
Former Member
Dec 17, 2010 at 11:32 AM

VLOOKUP and COUNTIF funtion in BOXI

333 Views

Hi,

I am new to Business Objects, so I have very basic knowledge in it. What I am looking is to create some formula like VLOOKUP and COUNTIF function as in excel.

I have two queries:

Query A: List of all old clients

ClientIDs- 123,124,124

ContactDates-01/04/2010,02/04/2010,01/04/2010

Query B: List of clients during some reporting period

ClientIDs: -123, 125,124,126

What I want to do is to identify the old clients in QueryB - and pull the Contact Dates from the Query A to query B. Also the other issue I am facing is because ClientIDs are linked, when I create some funtion it is also populating all the ClientIDs in Query B report which I don't want to happen.

Hope I was able to explain it you

Many Thanks