>>>>>I have a report that prints Value/Variance *100 %. I'm wondering, what do you think I should print in case of 0 for the Variance?
>>>>
>>>>First, make sure that Value/Variance is meaningful. For financial reports it's more common to report variances as a % of the original budget value i.e. Variance/Value * 100. So, you wouldn't have to worry about the variance being 0.
>>>>
>>>>If the budget value was 0, then report 0 as the % variance.
>>>
>>>This is not the financial report, it's the weight difference. I put nothing in case of 0 (actually, suggested it in my e-mail), but wanted to double check.
>>
>>Again, weight differences/variances are most commonly expressed meaningfully as a percentage of the nominal weight, i.e.
>>
>>(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 >
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up