Last Modified Date: 08 Feb 2017
ResolutionMove the IF statement inside the aggregation. For example, the following calculation:
IF MIN( [Region] ) = "Central" THEN SUM( [Sales] ) END
SUM( IF [Region] = "Central" THEN [Sales] END )
CauseWhen [Region] is not in the view, then every partition will return one value of [Region]. If the returned minimum value of [Region] matches the condition then all values for all regions will be returned, otherwise no values will be returned.
For example, if a particular customer does business in multiple regions, but the first region in the list is "Central" then MIN( [Region] ) = "Central" will be true for all transactions from that customer, and all sales will be returned.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials