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
Solved! Go to Solution.
You mean AVERAGE() ?
You mean AVERAGE() ?
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:
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?
just made it the main task row was not using the same record
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |