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
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.
Another way - create a representative sample qvw and share here and let us work on that.
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>';