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.
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
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.
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.
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.