Hello,
I tried to create a Metric (KPI) report but it seems that there is a bug with boolean fields.
If I use the following formula : COUNTIF([ID], true), it returns the total of entities on the DB on the scope of my filter, regardless of the value of this field. If I use COUNTIF([ID], false), it returns 0.
I’m not sure what you think the bug is. It is expected that COUNTIF([Id],true) will return a count of the number of entities (and COUNTIF([Id],false) will return zero).
What filter are you referring to?
Let say that I have a DB with 100 entities. This DB have a boolean field called “Bool” and for 20 of the 100 entities, the value is set to true.
On my report, if I write COUNTIF(Bool, true), the result will be 100 instead of 20. And if I write COUNTIF(Bool, false), the result will be 0 instead of 80.
In relation to the filter, I mean that I filter the source to restrict the scope, it’s just a detail, I don’t think it is relevant on my issue.
Example :
I have a DB with 10 entites
Test1 is a Checkbox field and Test2 is a Formula field that inverse the result of Test1.
The result on the Metric (KPI) report :
You have misunderstood how the COUNTIF function works.
Try this
COUNTIF([Id], [Bool]=='true')
Thanks @Chr1sG, it works.
