If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

detail filter if condition error

Started by div_1234, 05 Oct 2011 03:25:10 PM

Previous topic - Next topic

div_1234

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

blom0344

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

HalfBloodPrince

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