project_code | activities | target |
DP.2816 | # of name | 10 |
DP.2816 | # of xxx | 3 |
DP.2816 | # of yyy | 4 |
DP.2816 | # of zzz | 5 |
DP.2816 | # of zzz3 | 5 |
DP.2816 | # of zzz4 | 5 |
DP.2816 | # of zzz5 | 5 |
project_code | activities | updates |
DP.2816 | # of name | 15 |
DP.2816 | # of xxx | 13 |
DP.2816 | # of yyy | 44 |
DP.2816 | # of zzz | 95 |
DP.2816 | # of zzz3 | 75 |
DP.2816 | # of zzz4 | 95 |
DP.2816 | # of zzz5 | 57 |
CS.0000 | # of name | 799 |
CS.0000 | # of yyy | 878 |
activities | target | updates | |
# of name | 10 | 15 | |
# of xxx | 3 | 13 | |
# of yyy | 4 | 44 | |
# of zzz | 5 | 95 | |
# of zzz3 | 5 | 75 | |
# of zzz4 | 5 | 95 | |
# of zzz5 | 5 | 57 |
ForAll(
Filter(tblActivity_plan, project_code = listProject.Selected.project_code),
{
activities: activities,
target: target,
updates: Coalesce(
LookUp(tblActivity_update, project_code = listProject.Selected.project_code && activities = ThisRecord.activities, updates),
0
)
}
)
// For txtActivity
Text property of txtActivity:
ThisItem.activities
// For txtTarget
Text property of txtTarget:
ThisItem.target
// For txtAchievement
Text property of txtAchievement:
ThisItem.updates
project_code | activities | target | updates |
DP.2816 | # of name | 10 | 15 |
DP.2816 | # of xxx | 3 | 15 |
DP.2816 | # of yyy | 4 | 15 |
DP.2816 | # of zzz | 5 | 15 |
DP.2816 | # of zzz3 | 5 | 15 |
DP.2816 | # of zzz4 | 5 | 15 |
DP.2816 | # of zzz5 | 5 | 15 |
AddColumns(
Filter(tblActivity_plan, project_code = selectedProject) As AP,
Achievements,
Coalesce(LookUp(filteredIndicator, activities = AP.activities, updates),0)
)
ForAll(
Filter(tblActivity_plan, project_code = listProject.Selected.project_code),
{
activities: activities,
target: target,
Updates: Coalesce(
LookUp(tblActivity_update, project_code = tblActivity_plan[@project_code] &&
activities = tblActivity_plan[@activities], updates)
)
}
)
If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!
Thanks, and happy building!