3 Replies Latest reply: Jan 31, 2017 9:58 AM by Aviad Bein RSS

    If Condition for Multiple And values in expression

    Aviad Bein

      I All,

       

      I'm trying to write an expression with using if statement in order to sum multiple field values.

       

      I've got "Source" field with 2 values: Order, Invoice.

       

      I tried the following if statement:

       

      if(Source='Order' and Source='Invoice', sum(OrderUnits) + sum(InvoiceUnits),

        if(Source='Order', sum(OrderUnits), if(Source='Invoice', sum(InvoiceUnits))))

       

      but I get wrong numbers.

       

      I know that for multiple Or values I can use match(), in what function or condition can I use for multiple And values?

       

      Thanks in advance,

      Aviad