Hi,
I have a data lookup (Likelihood Scores) inside a repeating section.
I would like to get the max / highest score.
How can I get it?
See attached screenshots.
Best answer by Gavin-Adams
View original
How to Get the Max / Highest Number from Repeating Section
Userlevel 4
+12
The only way I could work it out was to put a number control in the repeating section
(set range validation to yes min 1 max 5, and data type integer.)
you could add a description or label to describe the numbers.
Then in a variable do a max function around the form.repeatingsection.intcontrol
Then I added the variable into a label outside the repeating section on the form.
It's not pretty but I couldn't see a way on the row by row to convert the text dropdown to an integer for use in the max function.
Hi Gavin,
Thank you so much for validating that we can't convert the text dropdown to an integer for use in the Max().
Will try the solution you recommended.
Cheers,
Michael
Thank you so much for validating that we can't convert the text dropdown to an integer for use in the Max().
Will try the solution you recommended.
Cheers,
Michael
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.