Skip to Content
Former Member
Sep 22, 2005 at 10:11 AM

Condition Top N incorrect Results calculation



Can anyone help!

I have created 2 Column Selections to enable a time comparison based on customers and there customer grouping. I have then created a top n condition to ascertain top 25 customers. To finish off my query i have created a formula to calculate % diff between the two selections. The problem I seem to be having is getting the variance calc. to calculate correctly on the results row. I have marked the selections to calculate results as summation however when I do this for the formulas I do not get the correct results. Am I missing something?