1 Reply Latest reply on Sep 22, 2016 8:19 AM by Łukasz Majewski

    Discrepancy in Totals between Table and Chart for LOD Calculated Field

    Craig Yurosko

      First time posting a question.

       

      Working with Blended data where I use several calculated fields (Plan Qty (PQ) and Shipped Qty (AQ)) as shown below:

       

       

      I have verified the values are calculating properly via this simple worksheet :

       

      I then created a dual axis chart and noticed my totals for AQ do not match the above worksheet (I have verified that the dataset and filters are identical) :

       

      I realize that AQ is null for the Oct-16 period (since I have not shipped anything in the future).  How do I rectify this ?

       

      Please let me know if more explanation is required.