In other examples, such as Example_Join_SM_10.5.twbx, the function EXCLUDE is used in the calculated field to create a scatter plot. When I tried doing the same with the second file, CNF.twbx, EXCLUDE doesn't even show up as an option in the Calculated Field. I tried looking it up in Youtube videos, other forums, and blogs but nothing addresses why I can't see EXCLUDE.
Your workbook is not working because it has an Access DB. The LOD calculations will work if you extract the data.
You have excel sources in the other workbook which support LODs