4 Replies Latest reply: Sep 16, 2014 10:07 AM by shravan goud RSS

    How to sum based on other column data

      Hi I have a data like this


      A B Amount_Type

      1 200 ZZZ

      1 300 XXX

      1 500 YYY

      1 300 ZZZ


      I want to sum column B if Amount_Type is ZZZ in straight table.


      IF(Amount_Type='ZZZ',Sum(B),) Is this correct??