COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cepete02 on 16 Oct 2008 10:23:54 AM

Title: Attempting to create a boolean variable with an "OR" for use in a cond format
Post by: cepete02 on 16 Oct 2008 10:23:54 AM
Hello,

I am attempting to create a boolean variable with the following condition in it:

(_months_between([Query1].[today],[Query1].[Time stamp]) >= 3) or ([Query1].[Time stamp] is null)

Unfortunately, it doesn't work.  If I create a variable with either the first, or the second condition in it, it works fine, but not in one condition with an "OR" between them. 

Any assistance would be greatly appreciated.

Carl
Title: Re: Attempting to create a boolean variable with an "OR" for use in a cond format
Post by: jahnavi on 17 Oct 2008 07:04:33 AM
I dont think so It works go for string variable and put it in the condition like if..else..then
Title: Re: Attempting to create a boolean variable with an "OR" for use in a cond format
Post by: cepete02 on 17 Oct 2008 09:05:23 AM
Thanks Jahnavi,

I did try that, and it didn't work.  It seems that when I put the _months_between() into the condition, the "field is null" portion stops working no matter what conditional structure I use.  I can't believe, though, that there isn't a way to do this, somebody out there must be doing this same thing!

Thanks Again,

Carl