Forum Discussion
Calculate From Another Table And Apply Filters From Other Table
I have two tables. My base table is using my PClaims table to calculate a median price by Affiliation and Code which I have in my formula shown below. It works well, except I have a problem when tryi...
Below is a screenshot of a very simple example of what I am trying to do. The PClaims is the raw data. Notice in yellow, B is missing Code "2". In my base table, I have it set up so that each affiliation_II has each code, so there is a line for Affiliation_II B and Code "2". The reason I have this Base table instead of just using PClaims is so that each Affiliation_II has every single code, even if it is missing in the raw data.
