use conditional explorer to hide a range of rows in a list ?

[herdan]

Hi guys,

Using RS 8.4 on framework.
I have following request. I have a list of customers and revenues as follows:
customer    revenue
A              6000
B              4000
C              2000
D              0
E              -3000
F              -5000
G              -7000

Now, using a Positive (eg 4000) and Negative (eg -3500) value prompt, I want to hide/exclude a range of rows so that the result list would be
customer    revenue
A              6000
B              4000
F              -5000
G              -7000

I tried using a filter ([revenue] >= ?Positive? and [revenue] < ?Negative?) but my list is empty.

How can I do this using Conditional Explorer ? The positive and negative values can differ according to the user requirement.

Any ideas are appreciated

[MFGF]

Hi guys,

Using RS 8.4 on framework.
I have following request. I have a list of customers and revenues as follows:
customer    revenue
A              6000
B              4000
C              2000
D              0
E              -3000
F              -5000
G              -7000

Now, using a Positive (eg 4000) and Negative (eg -3500) value prompt, I want to hide/exclude a range of rows so that the result list would be
customer    revenue
A              6000
B              4000
F              -5000
G              -7000

I tried using a filter ([revenue] >= ?Positive? and [revenue] < ?Negative?) but my list is empty.

How can I do this using Conditional Explorer ? The positive and negative values can differ according to the user requirement.

Any ideas are appreciated

A filter should be just fine for this.  I think the issue is with the syntax you tried.

Try coding it as

([revenue] >= ?Positive? or [revenue] < ?Negative?)

and make sure that the filter has its timing set to after default aggregation.

MF.

[herdan]

MFGF,

Thanks for pointing that out . Where was my head when I wrote this  ???

Anyway, it's working now.

Thanks again.