how to pass max of order numbers from a table to a variable input box.

[swetha54]

how to pass max of order numbers from a table to a variable input box .

We have a  table with order numbers 1 to 100 for ex, Variable should take the value as max(Order) = 100 .

Please help.

[Anil_Babu_Samineni]

Create a Variable in the design

vMaxOrder as variable Name

=Max(Order) as Definition

[swetha54]

Hi Anil,

Thanks for your reply!

But this didnt work.

[Anil_Babu_Samineni · Accepted solution]

Where this is not working? PFA

[jonathandienst]

Your requirements are not clear. Please expand on what you mean by "Variable should take the value as max(Order) = 100".

[swetha54]

We have a table with all the Order numbers as a column, and need to create a variable to hold max of all order numbers.

which should be passed to fetch the records from an API for that particular Order number.