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



      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?