2 Replies Latest reply on May 11, 2016 1:16 PM by Doug Stanley

    Help with an advanced(?) calculation

    Doug Stanley

      Here's my situation:

       

      I have 1,085 customers in my data. I need to compute an average for the subset of customers who have spent $1,000 or more. BUT ... I need to show all 1,085 customers compared to the average computed for the 126 customers who have spent at least $1,000.

       

      I get part way there with a FIXED calc that correctly computes the average for those who have purchased at or above the $1,000 threshold, but it also computes a second average for those customers falling below the threshold. I don't want the second average to be computed, rather I want it to display the average the was calculated off the subset of customers spending above the $1,000 threshold. Here's a snip:

       

       

      Can anyone please help me?

       

      Thanks,

       

      Doug