This content has been marked as final. Show 3 replies
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,