View records where null

[Sunil_Kenth]

HI,

I would like only to view in my straight table records where 'Date order placed' is blank.

This is expression i am using:

Sum( {$<[Date order placed]={“”}>} LineItems::PriceTotalSummary)

Can anyone tell me why this wont work?

Thanks.

Sunil

[swuehl]

I think that's because Null is not a value, so you can't select it (unless you specified NullAsValue in the load script).

But maybe this works:

sum(if(isNull([Date order placed])=-1, LineItems::PriceTotalSummary))

Regards,

Stefan

[kaushiknsolanki]

Hi,

    Do following settings.

    Go to dimension tab, Select the dimensions and uncheck the option "Suppress When Value is Null"

    Go to Expression Tab -> Uncheck "Suppress Zero Value"

Regards,

Kaushik Solanki   

[ToniKautto]

Maybe a if statement could be utilized if you are looking for Null values?

Sum( If( IsNull([Date order placed]) LineItems::PriceTotalSummary)