1 Reply Latest reply on Mar 8, 2018 2:48 PM by Deepak Rai

    Create a retention percentage with counts

    Alycia Geary

      I want to calculate a retention using the renewals from a year and dividing it by the grand total from the prior year (to exclude the new counts from the current year). For example, the calculation I want for 2017 would be 12,174 (or 15,598-3,424)/14,766, which would be 82.4%.