Calculate the sum of Values

(0) Share

Report

Posted on by RaymondAwo

Hi have a table with where each person has different project with hours

But when i got to the summary screen:

get values in fields where no value should be:
this is my code:

Sum(
Filter(
ResPers,
Name.Value in ResAllocation.Titel
),
Hours
)

So what I am trying to do is to get the sum of every value of the column Hours in the List ResPers where the Name is equal to the name of the Column Titel in ResAllocation. but for each name idividually.

Thank you all for the help

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RaymondAwo 41 on at

Like
a
(0)

Report
Copy link

Link copied!

so anybody has a solution for that ?
CU22040918-0 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RaymondAwo

At first glance, if no data returned, the filter condition could be the issue. Could you elaborate on it?

Sharing more screenshots about the data source, column type and some sameple data will be good.

Thanks,
Nelson

RaymondAwo

41 on at

Like (0)

Report

Copy link

Link copied!

Yes of course,

the List I am filtering from has the Names as drop down list (necessary for the Use-Case)

In comparison the Table where the Values fo ResPers should be compared to and the correct Sums of the Hours should be applied to is in a text label:

Here is some sample data

TitelNameProjectStartEndHoursElementtypPfad

1	Dummy1		13.07.2023	15.07.2023	1	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
2	Dummy1	Yetu	12.07.2023	31.07.2023	7	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
3		Yetu	12.07.2023	19.07.2023	6	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
4	Dummy1	BD	17.07.2023	17.07.2023	8	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
5	Dummy1	Yetu	17.07.2023	17.07.2023	8	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
6	Dummy 1	Yetu	18.07.2023	18.07.2023	8	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
7	Dummy 1		19.07.2023	19.07.2023	8	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
8	dummy 2		19.07.2023	19.07.2023	8	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
9	Dummy1		19.07.2023	19.07.2023	8	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers
10	Dummy 2	Yetu	20.07.2023	20.07.2023	8	Item	sites/TC-Ressource-PlanningDev/Lists/ResPers

Verified answer

CU22040918-0 195 on at

Like
a
(1)

Report
Copy link

Link copied!
Let's say that there is a gallery showing all Names from ResAllocation, so each line of gallery is showing the name.

To both show the sum value inside the gallery, try below code.

Sum( Filter( ResPers, Name.Value = ThisItem.Titel ), Hours )

Thanks,
Nelson
RaymondAwo 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you
It worked ❤️