# Calculations in SubSummary Report

**sccardais**Mar 5, 2014 4:39 AM

### Title

Calculations in SubSummary Report

### Post

I'm having trouble using Summary fields in a Sub-summary report formatted as a pivot / cross tab table displaying records from a Surveys table using a break field of Product_name.

Column 1 = Product_name. From Surveys table

Column 2 = Count of Surveys received from customers using each product category. This is a calculation field in the Surveys table.Count_Surveys

Column 3: Promoters. A summary field from Surveys table. Total of calculation field, c_Promoters in Survey table. c_Promoters value is 1 if score given by customer is 9 or 10

Column 4: Passives: A summary field from Surveys table. Total of calculation field, c_Promoters in Survey table. c_Promoters value is 1 if score given by customer is 7 or 8

Column 5: Detractors: A summary field from Surveys table. Total of calculation field, c_Promoters in Survey table. c_Promoters value is 1 if score given by customer is 6 or less

Column 6: c_Net_Promoter_Score: a calculation field in Surveys using GetSummary function to calculate the Net Promoter Score for each row (Product Name) using the following formula. Number of Promoters / total Surveys received for this product less Number or Detractors / total Surveys received for this product.

The calculation for c_Net_Promoter_Score (that is not working) is: (GetSummary(Summary zPromoter;Product)/Count_Surveys)-(GetSummary(Summary zDetractor;Product)/Count_Surveys)