Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What would you print in case of 0?
Message
From
03/07/2008 16:46:09
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01328757
Message ID:
01328874
Views:
6
This message has been marked as the solution to the initial question of the thread.
>>>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform