6 Replies Latest reply on Sep 12, 2019 5:27 AM by Marc Eltvedt

    How do i summarize rows depending on column value?

    Marc Eltvedt

      Hi everyone

       

      I have the following dataset, and I want to summarize Keys which have status of Error - but which haven't since had an instance that has Status=Completed

       

      So basically in the view below, ABC and GHI shouldn't be listed, since they have a row where the Status is 'Completed'

       

      I am struggling somewhat with creating a calculated field which will do this. Any ideas is appreciated.

       

      Thanks a lot,

      Marc