please see the attached
this will return the max risk value by name
your data brings in the risk value as a string so I had to convert it to a number using INT if you bring the value in as a number (or recast it to a number) you would leave the INT out of the formula
BTW you would want the risk as a number if you plan to do a difference between the value and the balance
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
max risk_v10.2.twbx 20.6 KB