Report Portal

Calculating a Proper Denominator Count

Suppose you want to calculate the average sales per customer. Logically, that just means dividing the Sales Amount by the number of customers.

A Simple—but wrong—Calculation

To get the number of customers, you can use the Count function. The following MDX query gives what, at first glance, seems to be the correct answer:

Read more...

 

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.