0

Is there any way to count filtered rows in formulate?

Hi together,

Is there any way to count filtered rows in formulate?

SID         Status

1             True

2             False

3             True

4             True

I need to count all rows and then just rows which are true, to create a calculation like 3 / 4 = 0,75% success rate.

Counting all rows worked for me with this query:

Count([Test].[Status])

But I don’t get a working method to count the filtered rows..

Count([Test].[Status].[True]) – Doesn’t work, I didn’t find a workaround

1 reply

null
    • "making the sophisticated simple"
    • AviPerez
    • 4 yrs ago
    • Reported - view

    Here is an example:

    it counts all states starting with "new" and deducts that from the total number of states. 

    count(AllMembers([customers].[State]) ) - count(StartsWith(AllMembers([customers].[State]) , "New" ) )

    You can replace the state hierarchy with a specialized list/set, which you would usually build first.

Login to reply

Content aside

  • Status Answered
  • 4 yrs agoLast active
  • 1Replies
  • 49Views
  • 2 Following