pls check the expression for range

[#1]

Hi,

Can anyone check this expression and say me where i had done mistake in  this.

=if(GetCurrentField(bc)={">=$(bcVar1)<=$(bcVar2)"} ,'Pass', 'Fail')

I am having a barchart along with slider, the above expression variable are min and max of the slider position.    Which is inrange that should get "Pass"  otherwise "Fail"

Actual requirement is, in my file having a straight table with 3 columns

one is group i.e; BC ,

second is Count,

third is Status.

EX: "It should look like this"

BC                             Count                        Status

0.16                            2                               Pass

0.17                           12                              Pass

0.17                            3                               Pass

0.18                            5                               Fail

0.18                           10                              Fail

I am using this expression in third column.

Thnks in advance..

[brenner_martina]

Hi,

the brackets {} are only used in set analysis together with aggregation: sum, or Avg, etc. You need only if-then-else like this:

If(bc>=$(bcVar1) And bc<=$(bcVar2),'Pass','Fail')