14 Replies Latest reply on Nov 19, 2016 12:40 AM by Marc MOUSSA

    Sum a field conditionally based on another field, and exclude the remain fields from full data

    davor kljucevic

      Hi,

       

      I want to take the sum of a field based on another field.

       

      I need it to behave as if I did

       

      SUM( IFF( [Field1] = "ABC", [Field2], 0) )

       

      the problem with this is when I view the full data, the rows where Field1 != 0 are still there.

       

      this works correctly if a make a set, but then I get 2 rows, in and out.

       

      can I have it both ways?