summing counts

[JoseGarcia]

hi there, 

trying to sum a result of three count. Using formula below, but got an error somewhere.
Could anyone help?
Thanks a million

=Count({<Action1_Status= {'In-Progress'}>} +
Count({<Action2_Status= {'In-Progress'}>} +
Count({<Action3_Status= {'In-Progress'}>}
ListItemsFromID_id)

[Dalton_Ruer · Accepted solution]

You need each count operation to be a standalone value. 

Count({<Action1_Status= {'In-Progress'}>}  ListItemsFromID_id) +  count2 + count3

[JoseGarcia]

Thanks a million! formula worked 🙂

[Dalton_Ruer]

Or if you use those progress flags a lot, create them as flags in the load script:

IF(Action1_Status = 'In-Progress', 1, 0) as InProgress1_Flag

Then your expression can simply be SUM (InProgress1_Flag + InProgress2_Flag + InProgress3_Flag)

[GaryGiles · Accepted solution]

Depends on what you are trying to accomplish and the structure of your data: you can union the sets, like this:

=Count({<Action1_Status= {'In-Progress'}>+<Action2_Status= {'In-Progress'}>+<Action3_Status= {'In-Progress'}>}
ListItemsFromID_id)

or have 3 count functions, like this:

=Count({<Action1_Status= {'In-Progress'}>} ListItemsFromID_id) +
Count({<Action2_Status= {'In-Progress'}>} ListItemsFromID_id) +
Count({<Action3_Status= {'In-Progress'}>}
ListItemsFromID_id)