How to calculate parent-level values in multiple columns (not just % Completed)?

Toghrul Rzayev

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 Variance
• Planned 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:

1. Apply roll-up logic to multiple columns?
2. 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.

Toghrul Rzayev

anyone? :(

prime_nathaniel

@Toghrul Rzayev use ancestor() to define if it is a parent or child row. Then you can use if() to use two or more different formulas in your formula.