You’re offline. This is a read only version of the page.
I am developing a marking form using a customised SP list. The marker selects from a drop down for different criteria - excellent, very good, good etc. The grades are linked to percentages e.g exceptional is 90%. I have these tabled in another SP list called 'Grades'.
I then want to convert these grades into actual numerical marks which will involve selecting the percentage then multiplying it by the weighting for that category. I have a numerical field for each category (mark1, mark2, mark3 etc) in the main data source which I want to set to this calculated mark. I'm presuming I need to filter on 'Grades' first - Title in this list is in the datacardvalue.selected.value, and then I want only Percentage in Grades. Once I have that percentage I want to multiply by 0.16 for example.
I'm a bit stuck on how to put this formula together though!
OK I may have worked it out. Formula I have used is:
LookUp(Grades, Title in DataCardValue9.Selected.Value, Percentage) *0.16
Share
Report
All responses (
Answers (
846
