I want one of the measures in my cube to be averaged, not summed or counted. 'sum' and 'count' work just fine; I have measures aggregated in both ways. However, the measure for which I selected 'avg' as the aggregation type still displays the sum. What might I be doing wrong? I'm attaching screen shots to help pinpoint the issue.
As an example, in the "Output.png" screenshot, I would expect the DaysOpen value for 12-009876 (about halfway down) to be 3, since each of the two lines under it is 3. I've also attached screen shots of the tree extract listing the measures available in this cube and the table transform where the DaysOpen measure is defined.
As an example, in the "Output.png" screenshot, I would expect the DaysOpen value for 12-009876 (about halfway down) to be 3, since each of the two lines under it is 3. I've also attached screen shots of the tree extract listing the measures available in this cube and the table transform where the DaysOpen measure is defined.