1 Reply Latest reply on Feb 28, 2017 10:01 AM by Norbert Maijoor

    Creating a calculated field for churn

    tommy durant

      I would like to create a calculated that would show when their is a churn/add.

       

      My data is structured like below.

      Imgur: The most awesome images on the Internet

       

      Basically, when a customer has revenue month 1 and no revenue month 2, that is a churn.

       

      When a customer has no revenue month 1 and revenue month 2, that is a add.

       

      The only way i can do this, is by creating a ton of calculated fields.  It seems like i should be able to do this in 1 or 2.  Any idea on how to set it up?

       

      attached workbook with sample data .