multiple values for a text box

[fcecconi]

hello

I have a table that contains multiple records(current and historical) for the same id.  I want to only display the current record in the text box.  There also can be more than 1 current records, so I really need to show the 1st current record.

thanks

[ramoncova06]

do you have a date ? or another field that you can use to obtain the latest information ?

this could be done only({<>})

only({< Date= {">=$(=(max(Date)))"}>}field)

[fcecconi]

Ramon

No, I only have an indicator for current or historical.

[ramoncova06]

ok, then use the current indicator in your set analysis

only({< Date= {<currentindicator={'Yes'}>}field)

[ramoncova06 · Accepted solution]

here is more details on set analysis A Primer on Set Analysis