Formula for Not Inlist?

building reports webintelligence
1

Hi All,
Please help me with the formula for.

Accounting Period Not In (0999;0900)

I created a formula like:

Not([Accounting Period]) InList(0999;0900)

But gives me error:
The expression or sub-expression at position 298 in the ‘Not’ function uses an invalid data type. (WIS 10037)

How do I create a formula for not inlist?

GNK_BO (BOB member since 2007-07-17)

2 
=Not([Budget_Period] InList (1,2))

Or if it’s a number, then also you can try -

=[Budget_Period] <> (1,2)

Truely speaking I haven’t tried any of these, but you can just try and let me know if it’s not working, then I will try to create one at my end.

Edit - Are you trying to filter those values or what actually you are looking for? That would help me to create the situation at my end.

aniketp :uk: (BOB member since 2007-10-05)

3

Desk-I code:

=If Not(<Budget_Period> InList (1,2)) Then 1 Else 0

Web-I code:

=If(Not(<Budget_Period> InList (1;2));1;0)

P.S: Not sure whether Web-I code is right. Try it out.

In your modified code, you misplaced one right parenthesis.

Jansi :india: (BOB member since 2008-05-12)

4

Not In ( ‘AAAA’,‘BBBB’,‘CCCCC’ )

this works for Oracle, note the comma separator

Xavier :ireland: (BOB member since 2006-12-18)

5

Hi Aniket,Jansi,xavier

Thank you all for your quick reply.
I have tried Aniket first code and it worked for me … so did not went to try other codes.

Not([Budget_Period] InList (1,2))

But really thanks for helping me

You guys are of great help…

GNK_BO (BOB member since 2007-07-17)