Can someone please help me with this issue I've been having? I'm currently trying to join two different data sets together, but can't find a good way to do it. Please see below for what my two tables look like:
In one table, I have a date and a return
In another table, I have a date and expected average return for that date:
Ideally, I'm just trying to calculate from the first table, what the Return - Expected Avg Return is for each date, so in theory it would look something like this:
Then, from there, I would just do Return - Avg Expected Return, and have an average of that number for each date. I keep running into the issue that I can't mix Aggregate and Non-Aggregate values -- anyone know an easy solution?