Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@fernandosanchez expression looks fine to me. try using double quotes as you are using search string in set
count({ <Duration={">9"}, InProgress={'1'}>} InProgress)
@fernandosanchez expression looks fine to me. try using double quotes as you are using search string in set
count({ <Duration={">9"}, InProgress={'1'}>} InProgress)
This fixed it, many thanks!😀 @Kushal_Chawda