Three conditional expression

[#1]

Hello,

I am struggling with something that seems relatively easy.

I need to use in my expressions three conditions:

A = 0

B <> 1

C <>2

Each condition comes from different table. I do not want to use list boxes for selection. I would like to have the conditions applied in the code.

What should be the expression for example for sum like =sum (conditions A,B,C) sales ?

[ariel_klien]

hi,

Try Sum({<A={"0"},B={">1<1"},C={">1<1"}>}Sales)

BR

Ariel

[Gysbert_Wassenaar · Accepted solution]

Try sum({<A={0},B-={1}>,C-={2}>}sales)

[#4]

Thank you guys. Those two seem to work.