Re: Want to create a filter based on a calculated expression
I'm not familiar with Association tables, but I'm not exactly sure how that works when you are calculating fields rather than using existing fields in the data. So in order to get visits I am summing Current_Util only when CostService = 'Primary Care'. So I'm not sure how you would associate both of those fields as you have described.
I think I over simplified the expressions because each category is a calculation like the one I just mentioned. And then I'm summing the risk flags to get an overall risk level.