Problem on expression with "or"

[Utop1984]

Hello all,

I have a problem on an expression today.

I try to chart data where I want the sum of C when field A or B = 1.

I tried the following :

Sum({$<A={1} or B={1}>}C)

But it always tells me there is an error...

Any idea ?

[martinpohl]

Sum({$<A={1}>*<B={1}>}C)

Regards

[sunny_talwar · Accepted solution]

Try this

Sum({<A = {1}>+<B = {1}>} C)

[Utop1984]

thanks a lot for your help but it seems this expression sends me a result when A AND B are equal to 1.

Nevertheless thanks a lot 🙂

[Utop1984]

Thanks a lot ! to be honest I didn't really understand the "Logic" but the result seems to be the right one...
As i don't see the "Or" operande I don't know how it can understand that I want results where A OR B = 1 ... This expression to me would have meant A AND B = 1, but it is working, so thanks a lot to you !!!

[sunny_talwar · Accepted solution]

Within set analysis

* = AND

+ = OR