calculate total percentage off subs tasks

[vacina_nesf]

Hi i made an app that has 3 tables, 1 named JOBS, other named MAIN TASK and the 3 one named SUB TASKS, each sub task has a progress 0 to 100 % i need a expression for the MAIN TASK and JOBS that calculate the totals of progress for the subtaskes

[Marc_Dillon · Accepted solution]

You mean AVERAGE() ?

[vacina_nesf]

i tryed this and didin't get any results, just tryed

AVERAGE(
SELECT(
SUB TASKS[% DONE],
[Main task]=[_THISROW].[Main task]
))

this is the Sub tasks table

this is the main task table:

[Marc_Dillon]

That expressions looks good (enough). What happens when you "test" it from the expression assistant, is the result correct?

I see that [% DONE] is a real column in your Main Task Table. Do you know the difference in when an App Formula evaluates in a real column versus a virtual column? 

[vacina_nesf]

just made it the main task row was not using the same record