expression not filtering view

[Anonymous]

Hi,

I have a very basic Chart.  I want to list all accounts where the flag on the account = 'Yes'. The two Expressions are:-

1. count(distinct AccountNo)

2. IsLocalBankFlag='Yes'

the second expression should filter out accounts but does nothing.  The two fields are in the same table.  Can I not do this?

Any help appreciated.

Cheers

[MK_QSL · Accepted solution]

count({<IsLocalBankFlag = {'Yes'}>}distinct AccountNo)

[Anonymous]

thanks Manish