Count With Multiple Conditions

[gfisch13]

Hi - I've been working with the following expression and I cannot seem to get the syntax correct.  I'm getting an error on the second half of the statement (highlighted):  Error in set modifier expression.  I'm not totally understanding what I'm doing wrong.  Any help is appreciated.....certainly, if there is a better way to accomplish this I'm all ears.  Thanks!  George

(count({$<[QuarterYearReceived]<=[QuarterYearClosed]>}), ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))

[Vegar]

Your red modifier looks fine. I think your issue lies within the first part of your expression.

Firstly you are closing the set expression before the red part comes in. Secondly the set below is not a valid set as you cant do <= comparisons as you have done.

{$<[QuarterYearReceived]<=[QuarterYearClosed]>})

[Taoufiq_Zarra]

@gfisch13  like ?

if([QuarterYearReceived]<=[QuarterYearClosed],count({<ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))

[Kushal_Chawda · Accepted solution]

@gfisch13  try below

(count({$<[QuarterYearReceived]={"=[QuarterYearReceived]<=[QuarterYearClosed]"}, ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))

[gfisch13]

Thank you all for your input!!!