Modifying formula in Calculated field - Admin Hours 2/4/16 1pm CT
None
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.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Ability to change / create the formula of your choice is part of the enhancement. ETA is Q2 - Q3 of this year. Will keep you posted on the exact dates.