Report Fields: Add Effort & Calculated Fields to Chooser
Hi Wrike Team!
We are using Wrike across our entire system integration facility, and I need a way to quickly calculate WIP (Work In Process) monthly for our assets. Our ERP system has all purchasing and commercial information by project, while Wrike has all labor by project. In order to properly calculate WIP, however, we need to know the percentage of labor which has been allocated (timelogged) per project against the quoted time (effort).
In table view, we use a calculated field of [Time Spent] / [Effort] and it works great! We can't use the same method in reporting, however. We need effort and calculated fields available for reporting!
I've seen other threads but I can't find any to upvote, so this is my attempt to start another thread!
Thanks everyone - great tool, we just all keep making it better together.
Brian
Hi Brian, welcome to the Community 👋
Thanks for the feedback, that's great to hear! This is an interesting suggestion, thanks for taking the time to detail it here. We've passed this on to the team.
If you haven't already, I'd recommend checking out our New To Community forum to learn how to get the best out of our resources here. Shout if you need anything else 👍
Elaine Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Elaine Wrike Team member Become a Wrike expert with Wrike Discover
Has there been any movement on this? It's like I can see some of our calculated fields in my reports, but not all. Those fields definitely exist in the location targeted by the report and I've also tried making them account fields, but still no dice.
I would also be interested in seeing this incorporated, specifically having Effort included as a selectable field when creating calculated fields in reports. The only work around would be to create a duplicate custom field that copies the value of the effort field and then do a custom calculation from that. But that is rather silly.
Hi Ali Moses Nick Etten 🙋♂️
Thank you both for sharing your feedback and detailing your use cases. At the moment, I don’t have any new updates to share regarding this suggestion. If there are any developments in the coming months, we’ll be sure to post an update here. Thanks again!
Rohan V Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Rohan V Wrike Team member Become a Wrike expert with Wrike Discover