How does the IF true/false formula works in reports

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

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

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

But none of them give the correct outcome.

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')

Awesome, thanks! :smile: