Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
u want to capture null values???
sivaraj s
Hi,
Use following set analysis to get null status Sales.
Sum({$<Status-={*}>} Sales)
Celambarasan
Hi lavanya,
Write the expression as:
{<FieldStatus={}>}. This may help you to capture all the null values of your Status Field.
Regards,
Pranav
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
Hi,
Sorry that is not working ..
try this
{$<field={' '}>}
Sivaraj S
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
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
Hi,
Explain little more briefer about the join between 2 tables and how the null value occurs?
Celambarasan