Correlation coefficient syntax

• It's necessary to use AVERAGE() expressions within the row iterating parameter to SUM(X) rather than measures.
• Measures are transformed into a filter context when inside a row operation resulting in a row being compared to itself
• Parentheses are used to control the order of operations to align with the Pearson formula definition