Obtain sum of subcategory

[mpsAutomation]

Hi,

I am tryin to make the Calculated rate the same acroos the parent task

calculate srate = budget/ forecast

The problem I have is that subtasks $ spent (spent*Calculated rate) do not equal the parent task result (in bold). So I need to make the calculated rate the same for the children of that parent task

I tried Sum(budget)/sum(forecast) but it gives me the rate of the entire job, e.g. children of task a and b, etc. is there a way to filter it? the same needs to be done for each parent task

Job A	Budget	Forecast	Calculated rate	Spent	$ Spent
Task a	39,130	258	152	86.3	13,088.83
Subtask a	11,180	86	130	0	-
Subtask b	27,950	172	163	86.3	14,023.75
Task b
Subtask d
Subtask e
Subtask f

[amitchandak]

@mpsAutomation , Try like

calculate(Sum(Table[budget])/sum(Table[forecast]), removefilter(Table[Subtaks]))

or

calculate(Sum(Table[budget])/sum(Table[forecast]), all(Table[Subtaks]))

Similar logic used here

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho