How to count the Blank records also?

building reports webintelligence
1

MY requirements is Bill = Blank, lst, Mgi,stp,hch.
i have one reports in that i use one objects called bill in query filter.I selected the values from inlist.But we want to include with Blank records also inn our filter?.I have selected 4 LOV but i have to ADD Blank also because we want to filter the numbers with Blank too.
how do i meet the condition by including 4 LOV and Blank.
Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

2

Hi Pooja,

Create a report variable like Bill (1) = If IsNull() Then ’ ’ Else (). That will replace your NULL with a space which will be visible in your LOVs for Bill.

vinod_menon :india: (BOB member since 2007-04-09)

3

Hello Vinod,
Thanks for your reply.Actually i have to count the Invalid Case Number.To determine the INvalid CAse.I have to filter the Data.So, either i need to create the Objects in the universe and place that objects in the query filter.
I don’t know the code to do it.
Thanks

ktm :us: (BOB member since 2008-11-12)

4

If the database you are dealing with is Oracle can you employ the NVL function to replace the NULL values with a dummy value and use that for your counting purposes or as a value in your LOVs too.

BOB_DW (BOB member since 2004-08-26)