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.
Can you post your twbx or share a snapshot of dimensions used in details in both axes?
What is the ZN within COUNTD() for - do you want to count missing records too?