Expression using or, and

[#1]

I need do a expression like this:

=count({$<B1_SU = {"8"} .or. B1_SU = {"12"}>} D2_QUANT)

Many conditions with the same field

it's possible?

[jagan]

Hi,

What is the condition to use B1_SU = {"8"} and B1_SU = {"12"}.  Try this

=count({$<B1_SU = {"$(=If(Condtion, 8, 12))"}>} D2_QUANT)

Regards,

Jagan.

[CELAMBARASAN]

Hi,

   Check with this

      =count({<B1_SU = {8}>+<B1_SU = {12}>} D2_QUANT)

using set operators

Celambarasan

[erichshiino · Accepted solution]

It can be very simple:

count({$<B1_SU = {'8','12'}>} D2_QUANT)

or even

count({$<B1_SU = {8, 12}>} D2_QUANT)

Regards,

Erich

[Anonymous]

That works when it's a single column basing on two values but what about an "or" when it's two values

Using the above example: 

This is assuming both values are in B1_SU

count({$<B1_SU = {'8','12'}>} D2_QUANT)

but what if I am looking at

B1_SU = {'8','12'}  or B2_SU = {'3','5'} 

So the "or" is based on two different columns.

Thanks

[nagaiank]

You may use

count({$<B1_SU = {8, 12}> + <B2_SU = {3, 5}>} D2_QUANT)