ADD VALUE TO DROPDOWN AND ADD UP THE TOTAL SCORE AND DIVIDE IT BY THE AMOUNT OF DROPDOWN BOXES THAT FULLFIL A CERTAIN CONDITION

[JCMEYER]

Hi,
I'm new in powerapps, I have created an APP with  a Edit Forms connected to a gallery, I my forms I have 32 Dropdown boxes with the following options: 

"ATIENDE" = 10
"PARCIAL" = 6
"NO ATIENDE" = 2
"NO APLICABLE" = 0 

Since I need to calculate the total score I created 32 textboxes with this formula:
[If(
DataCardValue156.Selected.Value = "ATIENDE"; "10";
DataCardValue156.Selected.Value = "PARCIAL"; "6";
DataCardValue156.Selected.Value = "NO ATIENDE"; "2";
DataCardValue156.Selected.Value = "NO APLICABLE"; "0";
""
)]
And I created a "TOTAL EVALUCIÓN" box with this formula:

"TOTAL EVALUACIÓN "& " " & Value('SUM30.01'.Text) + Value('SUM30.03'.Text)+Value('SUM31.01'.Text)+Value('SUM31.02'.Text)+Value('SUM31.03'.Text) + Value('SUM31.04'.Text) + Value('SUM31.05'.Text) + Value('SUM31.06'.Text) + Value('SUM31.07'.Text) + Value('SUM31.08'.Text) + Value('SUM31.09'.Text) + Value('SUM31.10'.Text) + Value('SUM31.11'.Text) + Value('SUM31.12'.Text) +Value('SUM31.13'.Text) + Value('SUM31.14'.Text) + Value('SUM31.15'.Text) + Value('SUM31.16'.Text) + Value('SUM31.18'.Text) + Value('SUM31.19'.Text) + Value('SUM32.01'.Text) + Value('SUM32.02'.Text) + Value('SUM32.03'.Text) + Value('SUM32.04'.Text) + Value('SUM33.01'.Text) + Value('SUM33.02'.Text)+Value('SUM33.03'.Text) + Value('SUM34.01'.Text)+Value('SUM34.02'.Text)+Value('SUM34.03'.Text) +Value('SUM34.05'.Text)+Value('SUM34.06'.Text)

The problem with this is that have made my APP really slow and I still need to divide the "TOTAL EVALUACIÓN" box, since the max score that can be optain is only 100 and with the formulas that I hava applied the total max score is 320, and I can't only divide it by 32, I need to count wich of the 32 dropdown boxes has been selected with values that aren't "NO APLICABLE".

A solution that I have come across is tho create another 32 textboxes and add a formula that count add "1" if the selected choice is "NO APLICABLE", and then the "TOTAL EVALUCIÓN" box divide it by "32 - (textboxes with the value "1" if the choice is "NO APLICABLE"), but this will make my app even slower.

Can someone please guide me to the best solution if there is one (I'm truly condifent that maybe I'm doing something awfull by doing it this way but is the only way that I have come with)

Thank in advance to anyone reading this.
PS: Sorry for the grammatics errors.

[TheRobRush]

I would recommend changing your dropdowns to something liek this

[
    {Value: 10, Text: "Atiende"},
    {Value: 6, Text: "Parcial"},
    {Value: 2, Text: "No Atiende"},
    {Value: 0, Text: "No Aplicable"}
]

do it for 5 of them named dropdown 1 - dropdown 5 so you can see how my solution works.

now place a label and give it this text property

With(
    {
    totalPts: Sum(
    ForAll([Dropdown1.Selected.Value, Dropdown2.Selected.Value, Dropdown3.Selected.Value, Dropdown4.Selected.Value, Dropdown5.Selected.Value] As choicesMade,
       choicesMade.Value), Value),
    applicableChoices:CountRows(Filter( 
        ForAll([Dropdown1.Selected.Value, Dropdown2.Selected.Value, Dropdown3.Selected.Value, Dropdown4.Selected.Value, Dropdown5.Selected.Value] As choicesMade,
       choicesMade.Value), Value>0))},

       totalPts &" / "& applicableChoices &" = "& totalPts/applicableChoices &" Avg Score")

personally, I would have likely not put 32 dropdowns in my app, thats a lot of controls to draw at once, maybe eventually place one in a gallery or something and let it repeat 32 times, or just one on screen that you can cycle through with a next button or something to keep memory usage down, but for now the above should help

[JCMEYER]

I wil l try it but i don't know how to assign value on a Dropdown box, can you help me with that?

[TheRobRush · Accepted solution]

you just put this

[
    {Value: 10, Text: "Atiende"},
    {Value: 6, Text: "Parcial"},
    {Value: 2, Text: "No Atiende"},
    {Value: 0, Text: "No Aplicable"}
]

as the items property

[TheRobRush]

and if dropdown shows number instead of text change this on rightside bar

[JCMEYER]

Thanks.