Is it possible to write a formula that excludes data?

building reports webintelligence
1

Is it possible to write a formula that excludes data from a table based on a condition in the formula? For example:

=If (IsNull([variable])) Then exclude this record

Is this possible?

P.S. I havent been able to get my query editor to exclude these nulls, so I’m trying to do it at the report level.

Brian Colón :us: (BOB member since 2009-04-10)

2

Can you offer up some more details? What are you trying to exclude from your results?

hcadar1 :us: (BOB member since 2008-04-25)

3

[quote:20744092a0=“Brian Colón”]=If (IsNull([variable])) Then exclude this record
[/quote]

Brian, you can’t explicitly exclude the data as you wrote above. But you can still use it like this.

flag=If (IsNull([variable]);1;0)

And now, apply a filter to the block/table which allows only 0s to be displayed.

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