Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to have a few text objects that count ITMSNumber where DaysPassed for the ITMSNumber is less than 5, then greater than 5 but less than 10, then greater than 10. Here's some pseudo code-
=Count(IF([DaysPassed]) < 5, ITMSNumber)
=Count(IF([DaysPassed]) < 10 > 5, ITMSNumber)
=Count(IF([DaysPassed]) > 10, ITMSNumber)
SelectInField-
ITMSNumber
DaysPassed < 5
etc.etc.etc...
May be these:
=Count({<DaysPassed = {'<5'}>} ITMSNumber)
=Count({<DaysPassed = {'>5<10'}>} ITMSNumber)
=Count({<DaysPassed = {'>10'}>} ITMSNumber)
UPDATE: Here you are( for selection)
To select < 5 ITMSNumber
Field
ITMSNumber
Search String
='(' & Concat(DISTINCT {<DaysPassed = {'<5'}>} Chr(34) & ITMSNumber & Chr(34), '|') & ')'
Do the similar for others
May be these:
=Count({<DaysPassed = {'<5'}>} ITMSNumber)
=Count({<DaysPassed = {'>5<10'}>} ITMSNumber)
=Count({<DaysPassed = {'>10'}>} ITMSNumber)
UPDATE: Here you are( for selection)
To select < 5 ITMSNumber
Field
ITMSNumber
Search String
='(' & Concat(DISTINCT {<DaysPassed = {'<5'}>} Chr(34) & ITMSNumber & Chr(34), '|') & ')'
Do the similar for others
It worked. Now all I need is the SelectInField action that will select only ITMSNumber where it meets the condition of <5, >5<10, and >10.
If you could edit your post and put it in there I will mark it as correct.
Thank you so much!
May be like this:
To select < 5 ITMSNumber
Field
ITMSNumber
Search String
='(' & Concat(DISTINCT {<DaysPassed = {'<5'}>} Chr(34) & ITMSNumber & Chr(34), '|') & ')'
Do the similar for others
Ok it worked. Throw it into your first response and I'll mark it as correct. Thank you so much!
Its done