Skip to content
English
Get more support
Create a Bloom Growth account
  • There are no suggestions because the search field is empty.

Formula - Rounding the result - RoundK

Details:

Sometimes a formula will have an excess number of digits when there is only a need to show just a few numbers after the decimal. Use the ROUNDK ( A; B ) expression to shorten the results of a formula. The ‘A’ portion is the formula, and the ‘B’ is the maximum number of spaces a number can display after the decimal point.

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 measurables' names on which you want to base your calculations. (Eg. Measurable1/Measurable2 or Measurable/0.2) 
  4. Type in “RoundK” at the beginning of the line. 
  5. Open parenthesis between “RoundK” and the mathematical operation.
  6. Type in a semicolon at the end of the mathematical operation/equation and the number of decimal places you want to round your results.
  7. Close parenthesis at the end of the formula.