So I have two different lists:
- contains skills, based on a role, with a Required Level (int)
- contains skills, based on personnel, with an Actual Level (int)
For reasons beyond my control, these have to be two seperate lists, but I want to be able to calculate the difference betweeen the Required and Actual fields in the two lists.
Can this be done with a calculated field or will I have to create a custom workflow?
Ultimately, these needs to be displayed on a page.