Home » Developer & Programmer » Data Integration » Aggregate data by average in Express
Aggregate data by average in Express [message #366939] 
Sun, 16 July 2000 10:29 
Maria Elena Estrella
Messages: 1 Registered: July 2000

Junior Member 


Within an Express Model, I need to do an rollup using average instead of sum. I have nearly 5 variables, each of them are related to 6 dimentions. Just one of these dimentions must do the rollup by sum, the rest of them have to do it by average.
Here is an example:
Client 90
Product 1 100
Material 1 80
Material 2 8
Material 3 12
Product 2 80
Material 1 50
Material 2 10
Material 3 20
In the case of aggregating the materials for a product, I should do a sum, but in the case of the client the aggregate is an average.
In the Express model it is needed to analize the average cost of the products, but we have an analysis of the materials that constitute the cost, that is why on the materials the values should be added in the
aggregation.
I havenīt found yet a manner to figure out the average as an aggregation method in Express; and Iīm still trying to do it via programming code, and make a formula but I have problems wiht this calculation when not all the cells that compose the cube have values, that in particular itīs my case.



Goto Forum:
Current Time: Fri Dec 02 06:45:12 CST 2022
