Forum Discussion

walkeras's avatar
walkeras
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Count the frequency of a boolean value

Hello everyone,   I have a database that stores the boolean values of a field that was collected. I am trying to count the frequency that the value appears i.e. the strucutre looks something like t...
Tutorial Requests
  • walkeras's avatar
    walkeras
    9 years ago

    Hey,

     

    Last night I had a brainwave and jumped out of bed and got it working using the following formula:

     

    TrueCount = COUNTAX(FILTER('Table',[Element_A]=TRUE()),TRUE())

     

    Thanks for the additional inputs as well, I will have a play with those other suggestions to see how else I might be able to solve the problem.

wlopezm's avatar
wlopezm
Regular Visitor
7 years ago

There is a simplest way to write the formula, and in my opinion, it is easy to read and understand.

 

COUNTROWS(FILTER(Table; Table[Element A] = TRUE()))