topic Re: Weighted % of funding calculation in Building Power Apps

Weighted % of funding calculation

cmilligan262 — Tue, 20 Apr 2021 15:19:56 GMT

I am trying to get to a weighted % of funding based on multiple criteria, business unit % funding of a project (static, pulling in from a data source), and % of time a person will spend on a project (changes from person to person, text in put). I currently have these set up as gallery's as the number of projects a person works on can change. The projects are selected from a combo box, the gallery then pulls in the project names and has a text input that I want to put in the persons % allocation for that project. I want these numbers to feed into another gallery that shows % of business unit funding based on the % the BU funds and the % of the persons time on the project. Currently it is just weighting based on what input box I have selected and not multiplying by the corresponding project. Any help is appreciated. Below is an example of what I'm looking to achieve.

Re: Weighted % of funding calculation

v-bofeng-msft — Wed, 21 Apr 2021 02:49:21 GMT

Hi :

Could you tell me if this can meet your needs?

If so,I've made a test for your reference:

I assume there is a table-TheDateBase

ClearCollect( TheDateBase, {Project:"Project 1",Found:"BU1",Static:20%}, {Project:"Project 1",Found:"BU2",Static:80%}, {Project:"Project 2",Found:"BU3",Static:100%} )

1\Add a gallery(Gallery6) and set it's Items property to:

Table({Split:"Project 1"},{Split:"Project 2"})

2\Add a TextInput(TextInput1) control in to Gallery 6

3\Add an Other Gallery(Gallery7) and set it's Items property to:

Distinct(TheDateBase,Found)

4\Add a label control into Gallery7 and set it's Text property to:

Sum( ForAll( Gallery6.AllItems As GalleryAllItem, LookUp( TheDateBase, Project = GalleryAllItem[@Split] && Found = ThisItem.Result ).Static * GalleryAllItem[@TextInput1].Text ), Value )

Best Regards,

Bof