Selecting Nth value from list of values

Stimulsoft Reports.Web discussion
Post Reply
evflores001
Posts: 19
Joined: Wed Dec 02, 2020 9:21 pm

Selecting Nth value from list of values

Post by evflores001 » Tue Jan 26, 2021 8:01 pm

Hello,

I was wondering if it is possible to select the Nth value from a list of values.

For example, say I have a list of loans and I wanted to select the second biggest loan, how could I do so?

Thank you.
Lech Kulikowski
Posts: 3436
Joined: Tue Mar 20, 2018 5:34 am

Re: Selecting Nth value from list of values

Post by Lech Kulikowski » Wed Jan 27, 2021 9:08 am

Hello,

You can sort Databand by the necessary value and use Line==2 in the Filter or Conditions.

Thank you.
evflores001
Posts: 19
Joined: Wed Dec 02, 2020 9:21 pm

Re: Selecting Nth value from list of values

Post by evflores001 » Wed Jan 27, 2021 9:34 am

Awesome! Thank you
Andrew
Posts: 4035
Joined: Fri Jun 09, 2006 3:58 am

Re: Selecting Nth value from list of values

Post by Andrew » Wed Jan 27, 2021 10:27 am

You are welcome!
Post Reply