This content has been marked as final.
Show 1 reply

1. Re: Correlation Calculations
Michel Caissie Apr 27, 2016 12:12 PM (in response to Ramakrishnan R)I assume you followed the example from Re: Re: Matrix Calculation
I cant comment on the formula itself but if I compare both views,
what you are missing is the YEAR(Date) on the Detail shelf and also the Table calculations Calculation Definitions.
If you rightclick on the green pill Correlation and select Edit Table Calculation,
go in Advanced and check the Calculation Definition for the three Calculated Fields.
And check also the Calculation Definition for the index filter.
Michel

Stock_Correlation(ed mc).twbx 53.5 KB
