Groovy Script to return a value of an intersection selected from a SmartList in a form
Summary:
We have a requirement to have a planning form that based on the Pay Table, Grade and Step selected in the columns, the Salary should prepopulate. The Salary amounts for each grade and step combination are already established on another form. The Pay Table, Grade and Step are all manually created SmartLists on the planning form. The salary amounts are currently at the intersection of Grade and Step where the Grade hierarchy lives in the Measure dimension and the Step hierarchy lives in the Account dimension. Currently the code we have looks up the SmartLists for Grade and Step and
0