How to write OR condition in set analysis

[#1]

HI all,

          How to write  OR condition in set analysis.???

[danielrozental]

You can't do an OR with different field conditions, what you could do is use more than one expression.

Why don't you post your expression so we can help you?

[#3]

Thank you for reply.I want to write the equation as follows

=count({$<Qty_no={'23'},Value={"9"} or {"10"},YEAR={'2012"}>} Sales)

[danielrozental · Accepted solution]

=count({$<Qty_no={23},Value={9,10},YEAR={2012}>} Sales)

[#5]

Thank you very much .one more question regarding the set analysis.How to include and exclude a set of values of different fields in set analysis.

=count({$<Qty_no={23},value{9,10},Year={2012}>} Sales)/count(Value{3,4,5},year={2012}

I included the values 3,4 and 5 in denominator and also want to exclude another set of values of  another field meanvalue ={1.2,2,3} from the denominator how can I exclude?

[danielrozental]

=count({$<Qty_no={23},value{9,10},Year={2012}>} Sales)/count({<Value={3,4,5},year={2012},meanvalue-={1.2,2,3}

[#7]

Thank you Daniel