Calculated metric showing the same values for every test group

[#1]

Hi all,

I am trying to create a simple standard deviation of revenue metric for a test set up in Adobe Target and available for reporting in Adobe Analytics. This test (Targeted Experience) has 20 groups, and i want to get the standard deviation of revenue for each group. However, when i create a calculated metric for standard deviation of revenue and add it to the test's report, i get the exact same value for each group, which is impossible.

I have added the image of the formula i used to create the calculated metric. Can you please tell me if i have made an error?

Thanks,

Mayur

AA Std Dev.JPG ‏13 KB