Posted 3 August 2017, 3:59 pm ESTHi,
I am evaluating the Active Analysis product and have an issue that I am hoping someone might be able to answer.
I have two raw measures in my data.
Volume (BCM - Bank Cubic Meter) and Cost ($)
I have created a measure called which represents Cost per BCM and set it to Average.
I have tried Aggregate, Distinct Sum and Calculated but none of those show any values
At the record level the Record cost / Record Volume = $/BCM
On the Active Analysis below, notice the AVG Loading $/BCM = 0.68. This is indeed the average but
that is not the answer I need. The correct answer is 11,150.77 / 19,785 = 0.56
I am sure there is a simple way of doing the and clearly setting the field to Average is not the answer.
Any assistance would be appreciated