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.
Selecting Nth value from list of values
-
- Posts: 21
- Joined: Wed Dec 02, 2020 9:21 pm
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Selecting Nth value from list of values
Hello,
You can sort Databand by the necessary value and use Line==2 in the Filter or Conditions.
Thank you.
You can sort Databand by the necessary value and use Line==2 in the Filter or Conditions.
Thank you.
-
- Posts: 21
- Joined: Wed Dec 02, 2020 9:21 pm
Re: Selecting Nth value from list of values
Awesome! Thank you
Re: Selecting Nth value from list of values
You are welcome!
-
- Posts: 21
- Joined: Wed Dec 02, 2020 9:21 pm
Re: Selecting Nth value from list of values
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).
For example, lets say I want to retrieve information from the second line of a databand (i.e., Line==2).
Re: Selecting Nth value from list of values
Hello.
You could add a data band and set Filter to Line==2.
Thank you.
You could add a data band and set Filter to Line==2.
Thank you.