This is a VERY busy workbook. I can't find the fields you are referring to.
What are the calculated fields you're trying to use for this problem in the two data sources? And what are the fields you are trying to blend on? (And what dimension group is each one in?)
also, I get this error when I open the workbook, but I think it's not involved in the sheet we're playing with (I assume Sheet 13), so maybe this isn't a problem for this thread:
Sorry for the cluttered workbook.
The two fields are mainly:
1. Hours occupancy KSA
2. C Duration Percentage
The Linkage is based on
2. Visit Date Formatted (from Customer Visits Datasource) Linked to Visit Date in SP Availability & SP Datasource