Calculating a Column Total
In a report - How can I calculate a Column Total? For example on a Status Report there is a auto generated Total for number of Projects i.e. 23 Projects. I need a report to calculate the column Total of Foretastedhttps://help.wrike.com/hc/en-us/articles/360003497114 saving from each project.
Can I do that?
Hi there! I may need a little more information around where and how this forecasted column is positioned.
Is it a Custom Field which is entered manually as a figure and you simply want to sum the total? Or does it require a little more mathematics across multiple Custom Fields?
If it's a summed total from one Custom Field, this number should sum up in your Reports already. If it requires a formula using multiple Custom Fields, you'll need to use one of the possible calculations outlined here. Once I know a little more I'll be happy to guide you through. Thanks 🙂
Calculated Fields in Wrike Reports allow you to make calculations based on data from Wrike fields (select system fields and Custom Fields).
Please note: 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.
More info on this on our Help Center.
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover