Browse articles

Adding your own figures

Add a formula column: build a formula from columns in the builder or type it free-form, choose its format, and make a reusable Fee per hour column.

What you'll achieve

Turn a figure no ready-made column offers into a real, sortable column, by writing a formula once.

You'll end up with: A reusable Fee per hour column, available from Custom formulas on every Projects report from now on.

Before you start

When the number you need isn't in any menu, write it

Building a report covers the Add Column menu's ready-made families and plain fields, with no formula required. Most questions stop there. Some don't: revenue divided by the hours behind it isn't a field on a project and it isn't a one-click aggregation either, it's a relationship between two columns that already exist. That's exactly what a formula column is for.

You may not need a formula. The Recipe in each Add Column panel adds, takes away, multiplies and divides Monument's own figures, with brackets and fixed numbers, and each part can have its own filters. Its totals are always worked out from the parts. See Building a report. A formula does the same with one more kind of line, the columns already on your report, and you save it once to reuse on every report of the same type.

A formula has two views of the same thing. Builder is the same recipe editor Add Column uses: lines, + − × ÷, brackets, fixed numbers and filters. Free-form shows the formula as text, with each column's name in curly braces, something like {Planned revenue} / {Planned hours}. Either way, the result becomes a real column: sortable, totalling, and recalculating live.

Name the column before you write the formula

  1. 1

    Open Add Column and choose New formula under Custom formulas.

  2. 2

    Name it Fee per hour, so the result reads clearly wherever the column ends up being reused.

    Step 2

The name isn't just a label. It's also how you'll reference this column from a future formula column, exactly the way you're about to reference Planned revenue in this one.

Build it from lines

  1. 1

    The formula opens in the builder. Click Add column and choose Planned revenue, the fee.

  2. 2

    Click Add column again, choose Planned hours, and set its operator to ÷.

    Step 2

The column list is the same one Add Column and every recipe line use: search it, and each choice has an info mark (?) with its definition. Monument's figures sit under Columns; the columns already on this report sit under On this report and are used as they are. A formula built in the builder that divides totals from its parts: the totals row shows total Planned revenue ÷ total Planned hours, not an average of the rows.

Free-form: the same formula as text

Click Free-form to see and type the formula as text. The builder's lines appear there as {Planned revenue} / {Planned hours}, so nothing changes when you switch. Use free-form for anything the builder can't show, such as functions, comparisons, or dates. Insert column opens the same column list and writes the reference for you, so a name can't be misspelled.

Click Builder to go back. That works when the text fits the builder's shapes: columns, fixed numbers, + − × ÷ and brackets. Otherwise one line under the switch says why, and the formula stays free-form. A saved formula reopens in the builder when it fits, and in free-form when it doesn't.

Choose how the result displays

In the builder, Format follows what the recipe measures, as Add Column does: Planned revenue ÷ Planned hours is an amount per hour, so it shows Currency. Once you choose a format yourself, the builder leaves it alone. A formula typed in free-form starts as Number and the text never changes it. Choose Number, Currency, Hours, or Percentage, whichever describes the result. Monument stores the chosen format with the custom column, so the column displays the same way wherever you reuse it.

Save it once, reuse it everywhere

  1. 1

    Click Save Column. Monument adds Fee per hour to this report immediately.

  2. 2

    The totals row calculates the formula across every matching row in the report, not only the rows visible on the current page.

A formula column isn't trapped inside the report that created it. Once saved, it shows up in Custom formulas in the Add Column menu on every report over the same entity, so the studio defines its version of a figure like this exactly once instead of six almost-matching spreadsheets each doing it slightly differently. The same section contains New formula and New time series, alongside saved choices you can find by name.

In free-form you can also subtract one date column from another, {End date} - {Start date}, say, and Monument counts the result in whole calendar days, useful for a duration figure no ready-made column tracks directly. A free-form formula that divides adds up its rows' values in the totals row; one built in the builder works its total out from its parts.

Troubleshooting

  • "Unknown column" on a reference that looks right. The name has to match exactly, including capitalization and spacing. Delete the manual reference and use Insert column instead, it can't misspell a name.
  • Builder won't open for a formula. The line under the switch says why: the formula uses a function, a comparison, or a date column. Keep it in free-form.
  • The result uses the wrong units. Edit the custom column and choose Number, Currency, Hours, or Percentage from Format. If you choose Percentage, keep the formula result as a zero-to-one ratio.
  • A formula column can't be filtered on. Filters work against a row's actual properties, not a calculated column. Sort by the formula column instead, worst or best first reads the same and needs no filter.
  • The column isn't in Custom formulas on a different entity's report. A custom column is scoped to the base entity it was built for. Fee per hour, built for Projects, won't appear on a Time Entries or Invoices report.

Where this fits next

This is step 3 of Answer questions with reports. For more on period columns, see Time-series columns. Next, share a frozen copy of a report.

Search Monument help

Search help articles and open a result.