Text Object and Action that will Count and Select a variable whose value is greater than or less than a number

[#1]

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...

[sunny_talwar · Accepted solution]

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

[#3]

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!

[sunny_talwar]

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

[#5]

Ok it worked. Throw it into your first response and I'll mark it as correct. Thank you so much!

[sunny_talwar]

Its done