Margin Calculation

user03543
user03543
in Dataflows

I am trying to calculate the average margin.

 

I have two columns: margin for the item and units sold.

 

For example:

 

If i sold 50 units at 30% margins and 2 units at 50% margin, my average margin would be roughly 31%

I need to do a summation of total units and total margin %

 

If I do not have the summation my average margins would be incorrect and show 40%.

 

How do I put that calculation in Beast Mode?

 

Thanks!

Comments

Categories