Hello Everyone,
I'm trying to count the number of checked checkboxes by a category ( group by item ) and have the same result in a new column of the same gallery.
example :
in the red box is what I want to achieve
I tried with the formula below but Im getting a circular reference error.
Is there any was to achieve this please ?
Thanks in advance
Hi TOJMK,
In my opinion, if you want to use a formula with gallery. You can't directly use this in the gallery inside. Otherwise it will cause some direction mistake.
Thanks,
Maceo
Solution in my thought:
1.Change the Oncheck&OnUncheck function for Checkbox, use a variable to store the number of checked.
Set(
var1,CountRows(
Filter(
Gallery1.AllItems,
Checkbox1.Value
)
))
2.Use the variable for the text in Label
Hope this can help you.
Thanks,
Maceo
Hi Maceo,
thank you for your reply, with the proposed solution I can not get the number of checked without group by.
what I want to achieve is a count group by item ( like the screenshot ITEM1 = 2 , ITEM2=0)
Oh, probably I got what you mean, you want to show the total amount that checked in Item1 etc.
Is I correct? It will be a great challenge.
Thanks,
Maceo
yes, any idea or solution for this topic?
User | Count |
---|---|
260 | |
109 | |
93 | |
57 | |
41 |