During today's admin hours session, I brought up a question about being able to change the formula used to calculate percentages in the Calculated Field option. We're taking the # of enrollments into our certification courses, and would like to use the successful completion percentage to help set score of one of our measures. The successful completions are tracked as "certificates" in the account record in SF. I would like to use certificates as "B" and enrollments as "A", and simply have a function of B/A for percentage of successful courses. Right now using the formula of ((A-B) / 😎 * 100, and switching the 2 variables, would result in a negative integer as the numerator. We need A-B/A or simply B/A, or the ability to create a formula of any shape with the variables that are loaded into Gainsight.
Already have an account? Login