Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I want to get the maximum phase number that is common in the current selection set of data and the set of data where season = last year's season
Ok
the user selects current season say it is 122 then last year's season is 112
max(PhaseNo) gives 1
max({<Season={$(vLastYearSeason)}>} PhaseNo) gives 5
knowing that $(vLastYearSeason) is 112
and if I put PhaseNo is a list box then when season is 122 then I have only Phase 1 in white
whereas when season is 112 i have phase 1 to phase 5 in white
Please advise
I solved it this way
I created a variable with the following definition
=max(PhaseNo)
and let's say I gave it a name newVariable...
then I modified the expression as follows:
max({<Season={$(vLastYearSeason)}> * $} if(PhaseNo<=$(newVariable),PhaseNo))
use set modifier $1 for previous selection.
I solved it this way
I created a variable with the following definition
=max(PhaseNo)
and let's say I gave it a name newVariable...
then I modified the expression as follows:
max({<Season={$(vLastYearSeason)}> * $} if(PhaseNo<=$(newVariable),PhaseNo))