>>>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
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