cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gazzo1967
Level 8

Sum Selected values from choice fields

Hi

How do i sum the selected text values from choice fields?

 

My scenario is

combobox1 . = completed, not completed, in progess

combobox2  = completed, not completed, in progess 

combobox3  = completed, not completed, in progess

 

i want to Sum the number of times each value has been selected by count into 3 textboxes

 

Sum(If(Value(combobox1.Selected.Value) = "completed"),1,0)

 

I know i have to use 

SUM() with combobox.selected.value = "completed" and combobox2.selected.value = "not completed"

but i cant get the syntax for the formula right

 

Any help appreciated

Gary

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Sum Selected values from choice fields

To do the Sum you use "," instead of the && so like this:

 

Sum(If(cb_1.Selected.Value="Completed",Value("1"),Value("0")),If(cb_2.Selected.Value="Completed",Value("1"),Value("0")),If(cb_3.Selected.Value="Completed",Value("1"),Value("0")), If(cb_4.Selected.Value="Completed",Value("1"),Value("0")), If(cb_5.Selected.Value="Completed",Value("1"),Value("0")))

View solution in original post

9 REPLIES 9
Super User
Super User

Re: Sum Selected values from choice fields

Try using CountIf instead.

gazzo1967
Level 8

Re: Sum Selected values from choice fields

@rebeccas 

hi

i thought countif counts a column.

i want to sum the number of times each combobox value is selected.

 

 

Super User
Super User

Re: Sum Selected values from choice fields

Yes and no...if you put them in a gallery you could also use it.

 

If they are just free standing you could either try setting a variable that does the count...something like:

 

OnVisible=Set(varCount,Value("0"))

 

ComboBox1-OnChange = If(ComboBox1.Selected.Value="Completed", Set(varCount, Value(varCount + 1)),ComboBox1.Selected.Value="Not Completed", Set(varCount, Value(varCount - 1)))

 

But for that you would have to think through it not subtracting if they select 'Not Completed' right off...I know you can do that but I'm not thinking of how right off.

 

You could also do hidden labels that are next by the combo box that has an if statement to store a value and then store those. If(ComboBox1.Selected.Value="Completed", Value("1"), Value("0")) ....and then add those.

 

Or the rating hidden that has that same if statement above because those are naturally stored as values and easy to sum from.

 

The only way I think you can use the Sum is if you have the combo boxes putting values into a collection...which is another option. 

 

Sorry...lot's of choices. Just depends on how many you have to me. If you have less than 10 I would do the label that is hidden and stores value and add those and more than that I would put those selections into a collection where you could have the values in a separate column. 

 

Hope I wasn't just more confusing!!

 

 

gazzo1967
Level 8

Re: Sum Selected values from choice fields

@rebeccas 

Thank you so much for the response 🙂

 

i have 5 comboboxes

how would i chain them together in a formula?

i tried

Sum(If(DataCardValue5.Selected.Value="completed", Value("1"),Value("0")
&& DataCardValue6.Selected.Value = "completed",Value("1"), Value("0")
&& DataCardValue7.Selected.Value = "completed",Value("1"), Value("0")))

 

this just gives me a count of '1' even if all 3 boxes are selected completed

 

Sorry im struggling with this one and no doubt its a simple solution 😞

Gary

 

 

 

 

 

gazzo1967
Level 8

Re: Sum Selected values from choice fields

@rebeccas 

my actual combobax values are these:

DataCardValue5.Selected.Value="a) read the instructions first", Value("1"), Value("0")

DataCardValue6.Selected.Value = "a) look at a map",Value("1"), Value("0")

DataCardValue7.Selected.Value = "a) follow a written recipe",Value("1"), Value("0")

Super User
Super User

Re: Sum Selected values from choice fields

To do the Sum you use "," instead of the && so like this:

 

Sum(If(cb_1.Selected.Value="Completed",Value("1"),Value("0")),If(cb_2.Selected.Value="Completed",Value("1"),Value("0")),If(cb_3.Selected.Value="Completed",Value("1"),Value("0")), If(cb_4.Selected.Value="Completed",Value("1"),Value("0")), If(cb_5.Selected.Value="Completed",Value("1"),Value("0")))

View solution in original post

Super User
Super User

Re: Sum Selected values from choice fields

That format makes it look confusing...this:

 

Sum(

 If(cb_1.Selected.Value="Completed", Value("1"), Value("0")),

 If(cb_2.Selected.Value="Completed", Value("1"), Value("0")),

 If(cb_3.Selected.Value="Completed", Value("1"), Value("0")),

 If(cb_4.Selected.Value="Completed", Value("1"), Value("0")),

 If(cb_5.Selected.Value="Completed" , Value("1"), Value("0"))

)

gazzo1967
Level 8

Re: Sum Selected values from choice fields

@rebeccas 

Thank you :0)

I can't believe it was using multiple IF... i knew i was missing something silly 😞

 

I'm very grateful for you help

 

Gary 🙂

Super User
Super User

Re: Sum Selected values from choice fields

Your welcome...sometimes you don't have to do the multiple Ifs but I think on this you will. 

 

A lot of times even if I don't have to do it multiple times I will first to make sure I am thinking it through and then remove them. With it just being the 5 I would just leave it though. 🙂

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,868)