Previous Value

[soha1902]

Hi All,

I have one "FiscalYearNumber" List Box, contains the following values:

41091

41456

41821

42186

I am writing one expression where I need to select less then value of selected value. For example If 42186 selected then I need to pick 41821. If 41456 selected then 41091 will be select.

How I write expression to do this?

Thanks

[MK_QSL]

You need to assign the same in script as previous flag...

Data:

Load * Inline

[

  FiscalYearNumber

  41091

  41456

  41821

  42186

];

Left Join

Load FiscalYearNumber, Peek('FiscalYearNumber') as PreviousFiscalYearNumber Resident Data

Order By FiscalYearNumber;

[sunny_talwar · Accepted solution]

May be this within your set analysis of your expression:

{<FiscalYearNumber = {"$(=Num(AddYears(Max(FiscalYearNumber), -1)))"}>}