Print Page - detail filter if condition error

Title: detail filter if condition error
Post by: div_1234 on 05 Oct 2011 03:25:10 PM

hi
i m trying to use detail filter and wanna to use this condition.

IF(([account1].[value]) ='notepad' ) then
if([account1].[book_value] is not null) then
([account1].[BOOK1])
else
(' ')

i m having parsing error,whats wrong in this.

How to if then in detail filter

Thanks

Title: Re: detail filter if condition error
Post by: blom0344 on 06 Oct 2011 02:38:50 AM

That is not a filter expression. A filter expression returns a true/false output, not the value of a dataitem. You can however use the code for a calculated data-item

Title: Re: detail filter if condition error
Post by: HalfBloodPrince on 14 Nov 2011 10:38:24 PM

Create calculation using that if else and then try to filter it.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: div_1234 on 05 Oct 2011 03:25:10 PM