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

[priyarane]

Hi Community,

Is ther any other solution as I have tried all the suggeste onces as above and still not getting my null value in my expression.

Ex:

(Sum({<%Month = {'Dec'},%Year = {'2015'}, INVOLVED_PARTY_NAME = P({<%Month = {'Sep'}, %Year = {'2015'}>}INVOLVED_PARTY_NAME)>}EAD)

-

Sum({<%Month = {'Sep'},%Year = {'2015'}, INVOLVED_PARTY_NAME = P({<%Month = {'Dec'}, %Year = {'2015'}>}INVOLVED_PARTY_NAME)>}EAD))

If I tried the expression for Null as seperate expression and I am getting value for null

Ex for Null:

if(len(INVOLVED_PARTY_NAME)=0 , (sum({<%Month = {'Jan'},%Year = {'2016'}>}EAD)) - sum({<%Month = {'Dec'},%Year = {'2015'}>}EAD))

If I add both like below and I am gettin only null value

(Sum({<%Month = {'Dec'},%Year = {'2015'}, INVOLVED_PARTY_NAME = P({<%Month = {'Sep'}, %Year = {'2015'}>}INVOLVED_PARTY_NAME)>}EAD)

-

Sum({<%Month = {'Sep'},%Year = {'2015'}, INVOLVED_PARTY_NAME = P({<%Month = {'Dec'}, %Year = {'2015'}>}INVOLVED_PARTY_NAME)>}EAD))

+

if(len(INVOLVED_PARTY_NAME)=0 , (sum({<%Month = {'Jan'},%Year = {'2016'}>}EAD)) - sum({<%Month = {'Dec'},%Year = {'2015'}>}EAD))

How to total inlude null value.

Pls some suggest.

[tresesco]

Another way - create a representative sample qvw and share here and let us work on that.

[Digvijay_Singh]

try replacing Null with some value in the script and then use this new value in expression to verify your data-

NullAsValue Field1, Field2;

set NullValue='<NULL>';