Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
@gfisch13 try below
(count({$<[QuarterYearReceived]={"=[QuarterYearReceived]<=[QuarterYearClosed]"}, ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))
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]>})
@gfisch13 like ?
if([QuarterYearReceived]<=[QuarterYearClosed],count({<ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))
@gfisch13 try below
(count({$<[QuarterYearReceived]={"=[QuarterYearReceived]<=[QuarterYearClosed]"}, ICMSCaseStatus={'Closed'}>} [ICMSCaseNumber]))
Thank you all for your input!!!