# How does the IF true/false formula works in reports

**URL:** <https://community.fibery.io/t/how-does-the-if-true-false-formula-works-in-reports/7628>\
**Category:** Get Help\
**Tags:** dashboard\
**Created:** [October 21, 2024, 9:05am UTC](https://community.fibery.io/t/how-does-the-if-true-false-formula-works-in-reports/7628 "2024-10-21T09:05:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [October 21, 2024, 9:05am UTC](https://community.fibery.io/t/how-does-the-if-true-false-formula-works-in-reports/7628/1 "2024-10-21T09:05:24Z")

</div>

I feel a bit stupid, but after reading the docs and asking Chappie I set aside my pride for this simple question 😅

The formula logic in reports is different from in Fibery.

How can I count only entities that matches a checkbox value?

Normally it’s

`Orders.Filter([Inclusief kassakoopje]).Count()`

In the reports I’ve tried

```auto
COUNTIF(
	[Public Id],
	[Inclusief kassakoopje] != ''
)

```

```auto
COUNTIF(
	[Public Id],
	IS_NOT_NULL([Inclusief kassakoopje])
)

```

But none of them give the correct outcome.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [October 21, 2024, 9:38am UTC](https://community.fibery.io/t/how-does-the-if-true-false-formula-works-in-reports/7628/2 "2024-10-21T09:38:28Z")

</div>

Checkboxes in reports behave as text fields, returning `true` or `false`, so you will need to use a syntax like this:  
`COUNTIF([Public Id],[Inclusief kassakoopje] == 'true')`

---

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [October 21, 2024, 10:17am UTC](https://community.fibery.io/t/how-does-the-if-true-false-formula-works-in-reports/7628/3 "2024-10-21T10:17:04Z")

</div>

Awesome, thanks! 😄

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [October 21, 2024, 11:14am UTC](https://community.fibery.io/t/how-does-the-if-true-false-formula-works-in-reports/7628/4 "2024-10-21T11:14:43Z")

</div>