Prefix & Suffix

How to add or remove a prefix or suffix in your formulas.

Last updated: Feb. 3, 2022

If you want to add currency, units of time, or other elements to your formula result, you can easily do it by adding a prefix or suffix in the formula editor.

  • Open the formula editor from your dashboard (see the video above) or go to KPI management > Formulas and create a new or open an existing formula.
  • Find the prefix and suffix fields and type in whatever you want to add to your formula result. For example, add "$" as a prefix, "min" or "EUR" as a suffix, or any other text of your choice.
  • To finish, click "Save" in the bottom-right corner.

Once saved, you will see the added prefix or suffix on your dashboard.

Adding prefix/suffix in the advanced formula editor

To add a prefix, click before the first parenthesis and type in the prefix. To add a suffix, click after the last parenthesis and type in the suffix.

Was this article helpful?