Loren,
Without knowing what the specs are, I made a guess. You did likewise. Either
could be correct. The issue was really how to do these calculations in the summary, group or page footer bands on a report.
Cheers,
Andrew
>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%.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.