Null inclusion

[priyarane]

Hi Team,

How to include null for the below expression

SUM({<%Month = {'Jan'},%Year = {'2016'},CURRENCY = {'$(=$(vCurr))'},INVOLVED_PARTY_NAME =P({<%Month = {'Dec'}, %Year = {'2015'},INVOLVED_PARTY_NAME ={''}>}INVOLVED_PARTY_NAME)>} EAD)

I want the null value for 'INVOLVED_PARTY_NAME'

- Thanks

[Chanty4u]

SUM(IsNull({<%Month = {'Jan'},%Year = {'2016'},CURRENCY = {'$(=$(vCurr))'},INVOLVED_PARTY_NAME =P({<%Month = {'Dec'}, %Year = {'2015'},INVOLVED_PARTY_NAME ={''}>}INVOLVED_PARTY_NAME))>} EAD)

[priyarane]

Hi Chanty,

it is wrong

[Chanty4u]

try dis

SUM({<%Month = {'Jan'},%Year = {'2016'},CURRENCY = {'$(=$(vCurr))'},INVOLVED_PARTY_NAME =P({$<%Month = {'Dec'}, %Year = {'2015'},INVOLVED_PARTY_NAME ={"*"}>}INVOLVED_PARTY_NAME)>} EAD)

[tresesco]

Try like:

SUM({<%Month = {'Jan'},%Year = {'2016'},CURRENCY = {'$(=$(vCurr))'},INVOLVED_PARTY_NAME =P({<%Month = {'Dec'}, %Year = {'2015'}>+($-<INVOLVED_PARTY_NAME ={'*'}>)}INVOLVED_PARTY_NAME)>} EAD)

[sunny_talwar]

May be this:

Sum({<%Month = {'Jan'},%Year = {'2016'}, CURRENCY = {'$(=$(vCurr))'}, INVOLVED_PARTY_NAME = P({<%Month = {'Dec'}, %Year = {'2015'}, INVOLVED_PARTY_NAME ={''}>}INVOLVED_PARTY_NAME) + {"=Len(Trim(INVOLVED_PARTY_NAME)) = 0"}>} EAD)

[priyarane]

Hi Tresesco. my result is same as before...

if this is not possible then how to show null values total for INVOLVED_PARTY_NAME

[tresesco]

You can show null related values (real nulls - hope you understand), using the set expression I showed above. I.e. -

Sum({$-<INVOLVED_PARTY_NAME ={'*'}>)EAD) would return data where your INVOLVED_PARTY_NAME is really null. If you have some  non-null values but some spaces or special characters appear as null, you might use expression as Sunny suggested below, however, that would not include the real nulls.

[engishfaque]

Dear Priya,

Try this one,

//include

INVOLVED_PARTY_NAME ={'Null()'}

or

//exclude

INVOLVED_PARTY_NAME -={'Null()'}

Kind regards,

Ishfaque Ahmed

[tyagishaila]

is INVOLVED_PARTY_NAME has NULL values or empty ?

try this,

INVOLVED_PARTY_NAME ={ }