1 of 1 people found this helpful
COUNTD(IF [order Date] = [Select Date] AND DATEDIFF('day',[order Date],[Select Date]) = 0 THEN [Unique_ID] END)
AVG(IF [order Date] = [Select Date] AND DATEDIFF('day',[order Date],[Select Date]) = 0 THEN [Cost] END)
Hope this could help. Let me if you have question.
This is because you have aggregated the Cost. One more thing i am struggling to get, why you have use AND operator. Both conditions looks same.
Still you can try the refer updated formula of Daily Sales and let's see the result. If not up to your requirement, please share the workbook with version.
IF ATTR([Order Date])=[Select Date]
THEN [Cost Effect] END
That's perfect! It's working without error.