All articles

Calculations on Reports

Calculated Fields are available on Business accounts and up and can be enabled from Wrike Labs by account admins. This is an experimental feature and as a result, it: may have bugs, is subject to change, and may be discontinued at any time. Please feel free to use the feedback links in Wrike Labs to share your thoughts on this beta feature.

⏱ 4 min read

Overview

Calculated Fields in Wrike Reports allow you to make calculations based on data from Wrike fields (select system fields and Custom Fields).

Important Information

  • When you create a Calculated Field, data is calculated on a task-by-task basis, data at the Folder/Project level is calculated via the formula, it is not aggregated from tasks.
  • Fields should have unique names in order to be used in Calculated Field formulas.

Create a Calculated Field

Regular Users on Business and up accounts can create Calculated Fields from task and Project table Reports which they've created.

  1. Open a Report.
  2. Click the gear icon located in the Report’s upper left-hand corner.
  3. Click "+ New Field" in the Calculated Fields section.
  4. In the pop-up window that opens enter a field name and the formula you want to use. There’s a detailed explanation on how to write formulas below.
  5. Click "Create".

The new Calculated Field is added to your Report as a new column.

Write a Formula

Calculated Fields are defined by formulas which trigger calculations on the data.  

Example: ([Custom Field name x]-[Custom Field name y])*2

Reference a Field

  1. Click the plus sign in the Formula field’s lower right-hand corner.
  2. Select a field from the list.

🔥Wrike Tip! If you know the name of the field you want to include in the formula, just type it’s name in brackets. For example: [Cost].

What You Can Include in Formulas

You can pull data from

  • Custom Fields: number, currency, percentage, duration, date
  • Default system fields: duration, time spent, date
  • Calculated Fields

You can also include

  • Constants (e.g. numbers)

Supported Operations 

  • Addition: +
  • Subtraction: -
  • Multiplication: *
  • Division: /
  • Today: TODAY()

In addition to the above, use parentheses to designate order of operations.

Possible Formulas and Resulting Data Types

Custom Fields can have different data types (e.g. number, percentage, text, etc). A Calculated Field’s data type depends on the data types of the Custom Fields used in its formula.

The table below shows which Custom Fields can be included together in formulas and what the resulting data type would be.

✋Important note!

  • Duration Custom Fields and Time Spent are calculated by hours.
  • Duration system field (i.e. duration of tasks and Projects) is treated as days.

How to read the table

  • Find the intersection of the two Custom Field types you want to include in your formula. Operations that can be performed between those two Custom Field types are listed. 
  • The color of operation designates what Calculated Field's data type is. Constant, Currency, Date, Days, Hours, Number, Percentage
  Constant Currency Date Days Hours Number Percentage
Constant +, -, x, /  +, -, x, / +, - +, -, x, / +, -, x, / +, -, x, / +, -, x, /
Currency +, -, x, / +, -, /   x, / x, / +, -, x, / x, /
Date +, -   - +, -    +, -   
Days +, -, x, /  x, /  +, - +, -, /   +, -, x, /  x, / 
Hours +, -, x, /  x, /      +, -, / +, -, x, /   x, / 
Number +, -, x, /  +, -, x, /  +, - +, -, x, /  +, -, x, /  +, -, x, /  +, -, x, / 
Percentage +, -, x, /  x, /    x, /  x, /  +, -, x, /  +, -, x, / 

Add an Existing Calculated Field

Add any existing Calculated Fields which reference fields included on the Report. You must be the Report creator to add Calculated Fields.

Add an existing field:

  1. Open the Report where you want to add a calculated field.
  2. Click the gear icon in the upper left-hand corner.
  3. You’ll see all fields which you can add to the Report. Check the box to the left of a field’s name to add it.

Edit a Calculated Field

Edit any Calculated Fields in Reports you’ve created.

  1. Hover over a field’s title in a Report.
  2. Click the carrot icon.
  3. Select "Edit Field".

A pop-up window opens where you can make changes to the field. Your changes are saved, and go into effect anywhere the Calculated Field is used. 

Delete a Calculated Field

Delete Calculated Fields in Reports you’ve created.

  1. Hover over a field’s title in a Report.
  2. Click the carrot icon.
  3. Select "Edit Field".
  4. Click "Delete".
  5. Click “Yes, delete” to confirm your decision.

The field is deleted and no longer available on any Report where it was previously added.

More Resources

Watch a video to see examples of Calculated Fields and see how to create a Calculated Field.
0 comments

Article is closed for comments.

Top