Forum Discussion
Calculate From Another Table And Apply Filters From Other Table
Super Usergillyr7 seems like you have one to many relationship between base table and pclaims,correct? Can you share sample data and expected result?
I will have to work on getting a same dataset. My original is huge so it will take sometime to gather a sample.
My PClaims table has the following fields: Affiliation_II, Affiliation_III, Payer, Year, Network, Code and Price.
My Base Table (Community_Prof) has the fields: Affiliation_II, Code, and Price using the median formula above. I have this Base table as a new table than the PClaims because the PClaims is the true data, where not all Affiliation_II's have the same exact codes. I created my base table so that they would all have the same fields, and that is why I am just pulling the median from it. (if it is missing I take the overall median).
I can filter the PClaims table, but the median from my Base table is not filtering down correctly. It is a many to many relationship based on Affiliation_II and Code.