Average process progress within sub processes

[Tech_Service]

I’m creating a data that will average all sub processes within it and return to be total average process progress for my project. I design the data that is a data loop but should not happened to be an infinite data loop. The designed is as shown in the diagram

it is deffinitely a loop but it is not infinite. But it seems this is not allowed in Appsheet. is there a work around on this?

[EIG]

How will you be displaying this data? If you use a chart, you can group by parent and average the progress. In that case, you would need to fill in the parent with its own key value.

[Tech_Service]

I mostly use CARD type display, not yet testing with chart type UI. the algorithm as you said the the parent column will be key value of its parent in the same datatable.

The problem occure once I add the main process key to subs’ parent column

the app stop working and error shows as follow

[Marc_Dillon]

Yes, Appsheet will not allow you to use circular expressions in most (possibly all) cases. I see it is a real column, not virtual, right? Are you using it as an App Formula?

I’d recommend setting up a chain of Actions to run when any of the [Progess] values are updated, that will re-calculate all parent [Progress] values. Perhaps as aForm Saved Behavior, or as a Bot.

[Tech_Service]

The [Progress] is a virtual collumn depends on the conditions defined in the diagram.

Thank you, I think that will solve the problem.