6 Replies Latest reply on Dec 1, 2018 3:12 AM by Jim Dehner

    Count number of records based on a condition

    Isaac Briseno

      I'm trying to make a calculation of how many Parent transactions were profitable or not

       

      Each parent transaction can have multiple sub-transactions and the defines whether it was profitable or not (sample table with green/orange highlighted cells)

       

      The final output I'm looking for is how many Parent transactions were profitable and how many lost money

       

      Any help is greatly appreciated

       

      Thanks in Advance,

      Isaac

       

      sampleOutput.png