Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Percentage in total line
Message
From
21/01/2000 16:13:59
Loren Fedje
Loren D. Fedje & Associates Ltd.
Chilliwack, British Columbia, Canada
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00320790
Message ID:
00321127
Views:
20
I disagree with your formule. Formule should be as follows:

iif(SumX = 0, 0.00%, round(((SumX-SumY)/SumY)*100,2)) gives you the correct percentage increase or decrease.

What is the percentage increase in amount from 90,000 to 100,000 - it is not 10% which is the result from your formule, it is 11.1%.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform