Is anybody able to share ideas on how they created Reports showing Renewal Rates for different time periods? And those Renewal Rates would change if i filter on Q1 Renewals, or Q1 + Q2, or Q4 Renewals, or 2016 Renewal Rates?
I've been creating rules to count the number of Renewal Opps, then load those numbers into an MDA calculated field, & calculate the Renewal Rate in Percentages. But I also want to be able to show Renewal Rates if i were to filter on Renewals that Closed in Q1 or Q2, or closed in 2016 or 2017.
I've been creating rules to count the number of Renewal Opps, then load those numbers into an MDA calculated field, & calculate the Renewal Rate in Percentages. But I also want to be able to show Renewal Rates if i were to filter on Renewals that Closed in Q1 or Q2, or closed in 2016 or 2017.