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 measurables those four measurables need to be filled out in order to work properly.

Steps: 

  1. Create a new measurable by clicking on the + sign in the top right corner of the Metric tile or in the “edit meeting” section. 
  2. Fill in the name of the measurable, select your goal, and click on the Formula checkbox on the right side of the screen. 
  3. Type in the measurable's name on 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 Measurable 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. You can round the results if is need it. (See below).

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