Calculation of correlation between two series
Is there a way to calculate correlation between two series? I tried both custom and aggregate formulae but couldn't make it. I guess the problem is correlation requires combining aggregate formulae (Avg) with custom formula (X-Avg(X)).