Help in Set analysis 'And' operator

[#1]

Hi,

As I need to exclude the values from the chart and the table if the status is 'A' and the Code is '#'

1. I would like to exclude the [Status] = 'A' and the [Code] =  '#', as I tried in the below but it exclude all Status 'A' invoices

=Count({$<[Status]-={'A'} , [Code]-={'#'}>}DISTINCT([Transactions]))

Regards

Chriss

[nizamsha]

=Count({$<[Status]={'*'} ,[Status]-={"A"}  [Code]-={'#'}>}DISTINCT([Transactions]))

[tresesco]

try:

Count({$<[Status]-={'A'} > * < [Code]-={'#'}>}DISTINCT([Transactions]))

[orital81 · Accepted solution]

You can always add a flag field (in the script or as a variable)

that will something like this:

If ([Status] = 'A' and the [Code] =  '#',1,0)

Then your set analysis will be more simple and easy to adjust

Count({<Flag = {'1'}>} DISTINCT([Transactions]))

[CELAMBARASAN]

May be like this

=Count({$<[Transactions]={"=[Status]<>'A' and [Code]<>'#'"}>} DISTINCT [Transactions])

or

Count({$-(<[Status]-={'A'} > * < [Code]-={'#'}>)}DISTINCT [Transactions])

[MayilVahanan]

HI

Try like this

Count({$-(<[Status]-={'A'} > * < [Code]-={'#'}>)}DISTINCT [Transactions])

[#7]

Hi All,

Thanks for your valuable reply now the expression is working fine...

Regards

Chriss