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
Calculated Fields in Wrike Reports allow you to make calculations based on data from Wrike fields (select system fields and Custom Fields).
Regular Users on Business and up accounts can create Calculated Fields from task and Project table Reports which they've created.
The new Calculated Field is added to your Report as a new column.
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
🔥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
You can also include
In addition to the above, use parentheses to designate order of operations.
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.
How to read the table
|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 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:
Edit any Calculated Fields in Reports you’ve created.
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 Calculated Fields in Reports you’ve created.
The field is deleted and no longer available on any Report where it was previously added.