This is my counter text outside of the gallery 46 - CountIf(GUATResponses, Title=vUserMail). I plan to add many more records to this. In my app the user will filter by scenario 1,2,3,4 or 5 with a combobox. When they choose each scenario I want either a new counter to go invisible or visible depending on scenario selected. Another way could be to use one counter label and alter my original formula. I am not sure of the best way to do this. The user selects scenario with a combobox box. I will tag all of items in my datasource as scenario 1,2,3,4 or 5 in a column called scenario. So, I just want to know I can have a counter label that will only count based on the scenario the user has filtered on.
You might want to try adding a second invisible gallery that implements all the filters you are employing. Then you counter could just be a CountRows() on allitems in that gallery.
I see, but I want it to only count based on the scenario so if there are 5 radio buttons in scenario one and someone checks 2 of them, I want the counter to say 3. If there are 10 buttons in scenario 2 and someone selects 3 i want the counter to display 7. @Pstork1
I was thinking something like this, I just dont know the syntax. If(ComboBox1_2.Selected = Scenario1, CountIf(GUATResponses, Title=vUserMail))
Sorry, I misunderstood. I thought you were trying to count how many records in the gallery fit the selected scenario.
Is there a way to alter my labels to reflect what I want. I am thinking either alter one label or create 5 labels and have them go invisible or visible based on combobox selection, then in the count label I would have to somehow say if Scenario = Scenario1 only show those counts. In my datasource GUAT, I added a column a called scenario and labeled each item with either scenario 1,2,3,4 or 5. @Pstork1
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks