Page 1 of 1
Selecting Nth value from list of values
Posted: Tue Jan 26, 2021 8:01 pm
by evflores001
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.
Re: Selecting Nth value from list of values
Posted: Wed Jan 27, 2021 9:08 am
by Lech Kulikowski
Hello,
You can sort Databand by the necessary value and use Line==2 in the Filter or Conditions.
Thank you.
Re: Selecting Nth value from list of values
Posted: Wed Jan 27, 2021 9:34 am
by evflores001
Awesome! Thank you
Re: Selecting Nth value from list of values
Posted: Wed Jan 27, 2021 10:27 am
by Andrew
You are welcome!
Re: Selecting Nth value from list of values
Posted: Thu May 06, 2021 12:19 am
by evflores001
Is it possible to call a specified Line from a data databand from a summary band? If so, how would I call it using a text box object?
For example, lets say I want to retrieve information from the second line of a databand (i.e., Line==2).
- StimulsoftLines.png (37.95 KiB) Viewed 2115 times
Re: Selecting Nth value from list of values
Posted: Thu May 06, 2021 5:44 am
by HighAley
Hello.
You could add a data band and set Filter to Line==2.
Thank you.