4 Replies Latest reply on Oct 12, 2018 1:15 AM by Ben Schwetlick

    Calculation Help

    Ben Schwetlick

      Hi all,

       

      I am trying to create a calculation to ensure that our product is working for our clients.

       

      We have 1 column that is either a 0 or 1. Each successful call (each call = 1 row) will have 1. Every unsuccessful call will have a 0.

       

      I am trying to create a calculation that if a customer has ever had a successful call they will be excluded from the list of customers who have failed. However, if there is ever an unsuccessful call the customer (SC_Name) still populates the list.

       

      I can't get my head wrapped around the Fixed Calculation to resolve this.

       

      This is what I have so far:

      { FIXED [SC_Name]: (if SUM(answered) = 0  then 1 else 0 end) } = 1

       

       

      AND

       

       

      { FIXED [SC_Name]: (if SUM(answered) > 0  then 1 else 0 end) } = 1 = 0