3 Replies Latest reply on Nov 8, 2013 6:27 AM by Matt Lutton

    Amount minus Avg(of Amount)

    Rebeca Araujo

      Hello everyone!

       

      I am trying to calculate a correlation between two column amounts. I have already calculated it (please see attached Correlation Tests.twbx). But what I am trying to do is just show the correlation result.
      If you see I am showing all the calculated fields, if I remove them I lose the result.

       

      I guess the trouble there is because calculated the fields Difference A and Difference B using (Sum(Amount) - AVG(Amount)), but actually I would like to do: Amount - Avg(Amount) but I am getting the agreggate vs non-agreggated error.

       

      Is there anyone that could help me with this issue?