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?