1 Reply Latest reply on May 25, 2016 9:28 AM by msa s

    Calculation Issue: Joining Two Data Sets for Calcs

    John T

      Hi all --

       

      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?