Formula - Calculating a Manual Average


Details:

Please take into consideration that this is not a real average formula, this helps you get an average when all the cells are filled out with the data, since this is the manual way of calculating the average, if you’re working with four measurable those four measurables need to be filled out in order to work properly.

Steps: 

  1. Create a new measurable by clicking in the + sign in the top right corner of the Scorecard tile or in the “edit meeting” section. 
  2. Fill in the name of the measurable, select your goal, click on the Formula checkbox on the right side of the screen. 
  3. Type in the measurable’s name in which you want to base your calculations off and add a plus sign (+) between each of them. (Eg. Measurable1 + Measurable2 + Measurable3) 
  4. Once you added all the measurables you want to use for the average, you can add parenthesis at the beginning of the formula and at the end, and divide it by the number of measurables you added. (See screenshot below) 

Video

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us