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,