Count if two conditions

[fernandosanchez]

Hi all,

I'm trying to make a count of a set of projects with two conditions: if the Projects are in progress (InProgress = 1) and the Duration is greater than 99.

I'm using this expression: 

count({ <Duration={'>99'}, InProgress={'1'}>} InProgress)

But the result is showing me 0...

Can you guys please help me?

Thank you!

[Kushal_Chawda · Accepted solution]

@fernandosanchez expression looks fine to me. try using double quotes as you are using search string in set

count({ <Duration={">9"}, InProgress={'1'}>} InProgress)

[Prem0212]

its showing zero means there is no relatable data for that combination so that the used expression is correct. If the expression is incorrect it will show the blank value

[fernandosanchez]

This fixed it, many thanks!😀 @Kushal_Chawda