Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
= if ([Date3 >= Date1 and Date3 < Date2, [Variable1_Description])
The above if expression is returning, Variable1_Description along with a null record. Why is the null record being generated?
Kindly suggest!
Thanks!
I don't see how this expression can return anything.
How can Date3 be >= Date1 AND also be < Date1?
= if ([Date3] >= Date1 and Date3 < Date2, [Variable1_Description])
An example to clear your doubt
if( 10th Feb > 1st Feb and 10th Feb < 28th Feb , [Variable])
is it creating null values in data load or during export to excel?? where are you using this expression?
I am using this expression in a straight table.
have you tried Checking ::Suppress when Value is Null >> in presentation tab
Hi ,
What if ur condition fails..U have not specified anything in else statement..
I mean ,
if ([Date3 >= Date1 and Date3 < Date2, [Variable1_Description],what????)
Then when ur given codn fails its returning nthn..So specify what exactly u want whn condition fails in else statement..Hope I m correct and it helps
Sachin
So whr even ur if condition not satisfying it's giving blank..Plss specify tht in else as said above..
Sachin
Or do u have any calculated dimensions with Aggr ()??