Help with Margin % expression, problem with division by zero?
I have two rows of data, Customer, Product, Cost & inputfields of New Price and New Volume
The Bid Sales is calculated by New Price * New Volume
The Bid Cost is Cost/LB * New Volume
The Margin $ Is Bid Sales - Bid Cost
And the Margin % is Margin $ / Bid Sales
This appears to work but when I put in values for the first product for the first New Price and New Volume the total for the Margin % shows 10% when I would expect it to be 50%, matching the single row of data's margin.
Re: Help with Margin % expression, problem with division by zero?
Ahh! I see now, thank you! I was trying to use the [New Volume] calculated for the column, instead of going straight to the data that is in the NewVolume... at least that is how I see it! Anyways, yes it works!