Custom or Calculated Fields Show the Wrong Numbers

Custom or Calculated Fields Show the Wrong Numbers

This article will address the following issue:

Custom fields in a Data Studio report return inaccurate calculations.



Solution

Type SUM () around each of the fields in your formula.



    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Troubleshooting Calculated Fields in Looker Studio

        This article will assist with calculated fields that are displaying incorrect results. Check Parentheses The most common cause of calculated field errors is missing parentheses. Type SUM(fieldname) around each field to obtain correct results.
      • All Fields Are Dimensions in Looker Studio Configuration Screen

        This article will address the following issue: Only dimensions appear in Looker Studio's configuration screen. All fields are green though metrics previously appeared in blue. Cause This is not an error. It was a part of Looker Studio's data modeling ...
      • Why Do the Sales Numbers Not Align with My Amazon Seller Central Reports?

        There are several reasons you might see different numbers when comparing the Amazon Seller connector with Amazon's reports. This article will help you troubleshoot reports that show different numbers from Amazon's in-house reporting. Minimizing ...
      • What Fields Are Available In PMA's Connectors?

        You can find the complete list of fields available for each connector in the Schema Explorer. Please see How to Use Schema Explorer.
      • Incorrect Inventory Numbers from Amazon Seller

        This article will assist with the following problem: Inventory numbers in an Amazon report are bloated or incorrect. Cause The most common cause of this problem is a missing marketplace dimension or filter. Even if you configure your account to ...