Forum Discussion
multi levels calculations
hello, i'd like to calculate complex (for me) calculation to obtain specific results. The aim is to avoid temporary table in order to calculate whatever the selection of the data is. My data...
- lbendlin
Super User
step 1 : attribute the average price (total price / sales) of A to the sales of B :I see that you have lines with multiple sales. That means you cannot just divide the total price by sales. You would have to identify the price of an individual sale and then average that out across all sales.
What is your definition of "average price" and why?
average price = total price / sales for each group (A, B, C, D).
the aim is to "standardized" the total price by using the reference of group B.
You will have the total price of A or C or D if you have the sales of B
