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])}



      But it isn't working