First of all, without seeing your workbook it's hard to provide constructive feedback. With that said, what about adding a new field to data source "A" with the code for analytic cases? You can then include that field in the join (or blend) conditions, and remove non-analytic cases via a filter. Alternatively you could create a new calculated field, which only takes the cancer patient volume as a value if the case is analytic. You could then use that field instead of the original one.
Thank you for your help! Reason why I didn't post a workbook its because it may have sensitive data and I don't know if company would be ok with that. Either way, thank you for your help!
Now regarding your suggestions:
1) adding a new field to data source "A" with code for analytic cases - there are 22 codes that make up analytic cases, so I don't think this would work.
2) Create a new calculated field, which only takes cancer patient volume as a value if the case is analytic - now this suggestion I like, however, I don't know how to create a calculated field that would account for the specific codes, would you be kind enough to help with that? a few codes are: 0, 00, 11, 12, 13, 14 and the name of the field is "case type"
Again, without seeing the file, I am just throwing out guesses. I was thinking something along the lines of
[IsAnalytic] : IF [case type] = 0 OR [case type] = 00 OR [case type] = 11 OR [case type] = 12 OR [case type] = 13 OR [case type] = 14 THEN 1 ELSE 0 END
[AnalyticVolume] : IF [IsAnalytic] = 1 THEN [Volume] END
The field [AnalyticVolume] will only have non-null values for analytic codes.
Thanks!! I'll give this a shot but I think your logic behind the script makes sense