Are you trying to find the number of orders placed on max/latest date in your dataset ?
since Countd is an aggregating factor you need to aggregate the T/F statement
then this (Note I used max because T is > F
you could als use attr()
will produce this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
1 of 1 people found this helpful
To solve the error, you just need move the if condition inside the count() function as shown below
COUNTD(IF [Calculation1]=TRUE then [Order ID] END)
Hope this helps
If i count it manually, its 4.