First and Second Max string as a Filter in Triggers

[thimma_paul]

Hi All,

Data is below. I to apply as a trigger , first and second Highest Max string in an action to open a sheet. Can any one help on this.

2014-Q3

2014-Q4

2015-Q1

2015-Q2

2015-Q3

[sunny_talwar]

May be use this as the select in field trigger:

='(' & MaxString(YearQuarter) & '|' & MaxString(YearQuarter, 2) & ')'

[thimma_paul]

showing error

[sunny_talwar]

Would you be able to let us know what error message does it give you?

[sunny_talwar]

May be this:

='(' & FirstSortedValue(YearQuarter, -Num#(PurgeChar(YearQuarter, '-Q'), '##')) & '|' & FirstSortedValue(YearQuarter, -Num#(PurgeChar(YearQuarter, '-Q'), '##'), 2) & ')'

[thimma_paul · Accepted solution]

tried with this

='(' & MaxString(YearQuarter) & '|' & left(MaxString(YearQuarter),6)&num(right(MaxString(YearQuarter),1)-1) & ')'

working fine now.

let me check with first sorted valeu