Hi,
In my project sheet, only the % Completed column rolls up automatically using parent/child logic. That works fine. But I want to do something similar in other columns, like:
Variance from Baseline (%)Weighted VariancePlanned Progress (%)
These are all calculated row by row, but I want to show an accurate value at the parent row, like a weighted average (similar to how % Completed works).
Is there a way to:
- Apply roll-up logic to multiple columns?
- Automatically calculate a parent row formula like
=SUM(CHILDREN(...)) / SUM(CHILDREN(...)) only at parent level?
Right now, I have to manually enter different formulas in parent rows vs child rows and I do not have the right result. My variance from the baseline should be 12%, i see 2% only.
Is there a better way?
Thanks in advance.
