Trying to create a calculated column in a List in SharePoint2013 Online based on 2 other columns that get values from another Lookup table(having a text column). So now my List looks:
Title Planned Original Difference
Proj1 2016W52 2016W51 1
Proj2 2017W1 2017W4 -3
Proj3 2016W52 2017W1 -1
The Difference = PlannedWeek- OriginalWeek. What formula could i apply to the calculated column in such a scenario.