Skip to Content
0

Webi quick filter vs. variable with a where clause

Mar 20, 2017 at 06:26 PM

58

avatar image

I have created a variable with a where clause to exclude two Funds (where Not(Fund) InList (1, 2) from the Expenses. If I use webi's quick filter and select Not InList from the drop down, then select 1, 2 from the list of available objects, I get a different result.
Can anyone tell me what the difference is between the quick filter and the variable with a where clause? (I do not want to filter at the BEx level, just one cell in the report.)

10 |10000 characters needed characters left characters exceeded

can you share the screenshot

0

see screenshot

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bonnie Russell Mar 20, 2017 at 06:48 PM
0



I get a different amount for what looks like the same filter.


4fmse.png (22.0 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

ideally you should get same values with these options as you have single column in the table.

0

Yes. I have no other filters, sections or breaks that would alter the results.

0