Weighted % of funding calculation

[cmilligan262]

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.

[v-bofeng-msft · Accepted solution]

Hi @cmilligan262 :

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