linking columns in two tables with formulas
Hi,I have a table with 42 patients, with longitudinal sampling. Each day has 6 SOFA score components and the total SOFA score (the sum of the components) (see attached long table). Now I want to get that info into my short table (attached) which only has patients, where I have a column of the average SOFA score per patient, average of the 1st 3 days (0 through 3) and average of the 1st 7 days (0 t...