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.

walkeras's avatar
walkeras
Icon for Advocate I rankAdvocate I
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.

wmjhca's avatar
wmjhca
Frequent Visitor
7 years ago

Worked like a charm for me! Thanks!!!