Does anyone know how to calculate a prior balance based on current balance and increase/decrease?
Example:
Current Sales = 334858
Current Sales Increase over Prior Period = 335.3%
Prior Period Sales = ?
Does anyone know how to calculate a prior balance based on current balance and increase/decrease?
Example:
Current Sales = 334858
Current Sales Increase over Prior Period = 335.3%
Prior Period Sales = ?
Past Sales = Current Sales/(Percent Increase +1)
Percent increase is formatted as a percent
So in your example, the previous sales were 76925.80
Checking that
Percent increase = (Current - Past)/Past *100= 335.3
Does that sound right to you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Perfect. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks