>>>(Weight variance / Nominal weight) * 100
>>
>>Wow, I'm now thinking I created this report incorrectly. I need to divide by a weight, not a variance that is the difference between weight and other weights (they should sum up). I believe I messed up, let me re-check the requirement.
>
>If that's true, then your original problem goes away. I'm a great believer in not trying to fix problems that shouldn't exist in the first place < g >
Yes, you were right. Here is the requirement
And on the same report if possible she is also looking for each weight field to have the percentage of weight for each field relative to the stockwt.I worked at night (around 12am) and didn't realize my mistake.
BTW, what if StockWt is 0? I better add a check for this anyway :)
If it's not broken, fix it until it is.
My Blog