Urgent plz help - Set analysis

[#1]

Hi All,

     I have a field status which has values "Buy","Sell" and "Hold".Due to a join with another table nulls are coming in the status field.I want to capture them using set analysis how do i do that..I am using valuelist function as a dimension so need to group the nulls in the expression...

Any help is greatly appreciated..

Thnaks in advance.. Plz let me know if yu need any help..

[sivarajs]

u want to capture null values???

sivaraj s

[CELAMBARASAN]

Hi,

Use following set analysis to get null status Sales.

     Sum({$<Status-={*}>} Sales)

Celambarasan

[#4]

Hi lavanya,

Write the expression as:

{<FieldStatus={}>}. This may help you to capture all the null values of your Status Field.

Regards,

Pranav

[#5]

Hi,

I am sorry that is not working.. Just for ur info.. I have grouped the null values coming in the field as "Not defined" in the script.. The nulls that I am speaking are coming due to outer join with another table.. I need to capture them as well so plz let me know if u have any suggestions..

Thanks

[#6]

Hi,

Sorry that is not working ..

[sivarajs]

try this

{$<field={' '}>}

Sivaraj S

[CELAMBARASAN]

Hi,

     You grouped null values in the name of not defined within the load script right?So you can use

Sum({$<Status-={'Not Defined'}>} Sales)

Celambarasan

[#9]

Hi,

  The Null values are not coming from excel they are introduced due to a join with another table. I need to capture them.. Any suggestion please let me know..

Thanks

[CELAMBARASAN]

Hi,

     Explain little more briefer about the join between 2 tables and how the null value occurs?

Celambarasan