This content has been marked as final. Show 2 replies
Indeed this is possible in VBScript.
You don't have handy Max/Min functions in VBscript but given that you've only got three inputs, you can easily compare one number against the other two and deduce the maximum from there.
First of all, get the data from the 3 intersections you want using GetCell
Var1 = HS.GetCell("POVExpression")
Var2 = HS.GetCell("POVExpression")
Var3 = HS.GetCell("POVExpression")
Then do a simple comparison of the three values using something like below
If Var1 >= Var2 And Var1 >= Var3 Then
VarMax = Var1
ElseIf Var2 >= Var1 And Var2 >= Var3 Then
VarMax = Var2
VarMax = Var3
The maximum value will be in the variable VarMax. You can now use HS.Exp to to assign that variable to the desired account