How to count unchecked boxes

1

I am having this problem where I want to count how many boxes are unchecked on my table per month.

image
image.png707×472 7.38 KB

the formula I tried was: [Report Gabriel].Filter([Report Gabriel].Month = MonthName(Today())).Presence.CountIf(CurrentValue = false)

but the value I got was always 0, I don’t know what happens, I wanted 2, since that’s how many unchecked boxes there are

3

@Pedro_Miguel_Rocha_Silveira

thisTable.Filter([Column 1]=MonthName(Today()) AND [Column 2]=false).Count()

2 Likes
4

Apparently the same formula I used worked now, and I haven’t changed anything, have no idea, but if it changes again, I’ll try your suggestion! Thanks

1 Like