2 Replies Latest reply on Nov 14, 2016 9:08 AM by Sherzodbek Ibragimov

    Quick Help: Need to get a sum of this calculated field

    Charles Foley

      Here is my calculaiton: http://imgur.com/a/tEmW9

       

      My Data is as follows: Customer, Product, Quality, Value, Used Sales

       

      We have two product lines and this is denoted by the quality field.

       

      If the quality is "total", i can simply use the value field and that is my total potential opportunity for that customer and product.. If the quality field is not "total", i need to do value * used sales .and that will show me my total potential opportunity for that customer and product.

       

      i want to sum my total opportunity from all customers and products. The above calculation works on a customer level, but it isnt summing correctly if i remove the customer ID from the table.