I have a list that that I am trying to create a calculated column for in my form.
I have 3 different director levels (A lookup field) - D 1, D2 and D3.
I have another lookup percentage field ranging from 85-100 for the 3 different director levels
I have a commission amount for the various director levels and percentage.
This is the query I am using for the calculated column, which is only bringing the first amounts for the three different director levels only
Does anyone know what I am doing wrong. How can I get the 86-100 amounts to populate.