Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
SUM(IsNull({<%Month = {'Jan'},%Year = {'2016'},CURRENCY = {'$(=$(vCurr))'},INVOLVED_PARTY_NAME =P({<%Month = {'Dec'}, %Year = {'2015'},INVOLVED_PARTY_NAME ={''}>}INVOLVED_PARTY_NAME))>} EAD)
Hi Chanty,
it is wrong
try dis
SUM({<%Month = {'Jan'},%Year = {'2016'},CURRENCY = {'$(=$(vCurr))'},INVOLVED_PARTY_NAME =P({$<%Month = {'Dec'}, %Year = {'2015'},INVOLVED_PARTY_NAME ={"*"}>}INVOLVED_PARTY_NAME)>} EAD)
Try like:
SUM({<%Month = {'Jan'},%Year = {'2016'},CURRENCY = {'$(=$(vCurr))'},INVOLVED_PARTY_NAME =P({<%Month = {'Dec'}, %Year = {'2015'}>+($-<INVOLVED_PARTY_NAME ={'*'}>)}INVOLVED_PARTY_NAME)>} EAD)
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)
Hi Tresesco. my result is same as before...
if this is not possible then how to show null values total for INVOLVED_PARTY_NAME
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.
Dear Priya,
Try this one,
//include
INVOLVED_PARTY_NAME ={'Null()'}
or
//exclude
INVOLVED_PARTY_NAME -={'Null()'}
Kind regards,
Ishfaque Ahmed
is INVOLVED_PARTY_NAME has NULL values or empty ?
try this,
INVOLVED_PARTY_NAME ={ }