detail filter if condition error

[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

[cognostechie]

What's the point of using a detail filter for this ? Use a Calculated column instead.

In a filter , the syntax should be like this -

If (....)  then (...) else (1=1)

This will return true if the condition is not met.