Hi, I am trailing Wrike to make sure it is best fit for our organisation and so far really impressed. As you can sense there is always a but. Mine is that I am trying to use template projects to prepare project estimates that can then move forward to a live project without reinventing the wheel.
The issue I have stumbled across is that when using the Aggregation SUM setting to arrive at total the calculations are way out because they are being applied to the various sub-totals for each phase/group.
At present I have two columns [Est Hrs] and [Est Rate] then in report I sue a simple calculated field to arrive at total ie. [Est Hrs] * [Est Rate]. All works fine except the fact that I cannot get a total for the estimate without "dumping" it into Excel and adding sum formula to total the calculated column.
Seems like a possible oversight since I notice Wrike calculates the totals correctly for [Time Spent] column in reports.
Similarly I want to be able to accurately report the variance between [Time Spent] and [Est Hrs] when multiplied by their respective cost and charge out rates but envisage that I will run into the same problem.
Love to know if anyone else has discovered a better workaround for this?
Thanks for taking time out to consider this post.