2 Replies Latest reply on Dec 26, 2018 11:39 AM by Lucio Ignacio Juárez

    Sum if for Multiple Criteria on the same Column

    Lucio Ignacio Juárez

      Hello everyone,

       

      I want to do another graph (linear) with the sum of Cash, Payables and Receivables. But I don't know how.

       

      It would be a sum if with multiple criteria. How would it go?

       

      I thought of doing it with:

       

      IF (ATTR([Concept]='Receivables' OR [Concept]='Cash Position' OR [Concept]='Payables'))

      THEN SUM([Amount])}

      END

       

      But it isn't working